{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:06:43.455334Z",
     "start_time": "2019-11-14T10:06:42.279481Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "os.chdir(r'D:\\数据')\n",
    "\n",
    "data = pd.read_csv('vip.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:07:47.991582Z",
     "start_time": "2019-11-14T10:07:47.909808Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cert_no_cipher</th>\n",
       "      <th>complete_time</th>\n",
       "      <th>is_overdue</th>\n",
       "      <th>mobile_nbr</th>\n",
       "      <th>user_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6E466B36515853576E66786A4A68693835627565534E74...</td>\n",
       "      <td>2019/4/18 2:24:59</td>\n",
       "      <td>0</td>\n",
       "      <td>15378923256</td>\n",
       "      <td>李瑞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>326C746C693562662B574B466B6D377048394B4D467855...</td>\n",
       "      <td>2019/4/16 3:43:56</td>\n",
       "      <td>0</td>\n",
       "      <td>15378935690</td>\n",
       "      <td>徐淑红</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>326C746C693562662B574B4B61654154623141686B3931...</td>\n",
       "      <td>2019/4/16 7:20:52</td>\n",
       "      <td>0</td>\n",
       "      <td>18095193521</td>\n",
       "      <td>宋鹏明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4D487A57514D35714F517A563547534B4B5130376D5636...</td>\n",
       "      <td>2019/4/15 6:43:27</td>\n",
       "      <td>0</td>\n",
       "      <td>13389520088</td>\n",
       "      <td>方超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2B5841667A34727A364F33786C7752573844667273547A...</td>\n",
       "      <td>2019/4/16 1:50:12</td>\n",
       "      <td>0</td>\n",
       "      <td>17709596636</td>\n",
       "      <td>王继权</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>45545942504A4748754D6E6356756277576F69375A6271...</td>\n",
       "      <td>2019/4/16 9:52:37</td>\n",
       "      <td>0</td>\n",
       "      <td>18161618494</td>\n",
       "      <td>杨忠良</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>676C4B564E2B32676A4C4C6931743048315369345A4D76...</td>\n",
       "      <td>2019/4/17 4:37:42</td>\n",
       "      <td>0</td>\n",
       "      <td>18195306761</td>\n",
       "      <td>马林</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>764B443842704B766A6C4A3865666F314C45786E42736B...</td>\n",
       "      <td>2019/4/16 10:27:53</td>\n",
       "      <td>0</td>\n",
       "      <td>18095453387</td>\n",
       "      <td>朱国斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5369526D63734C445375436E59694877314E3934625A50...</td>\n",
       "      <td>2019/4/16 4:42:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18095276294</td>\n",
       "      <td>吴自斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5369526D63734C44537543327965755839347661455177...</td>\n",
       "      <td>2019/4/19 11:04:43</td>\n",
       "      <td>0</td>\n",
       "      <td>15378930527</td>\n",
       "      <td>伍少波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>764B443842704B766A6C4B614356384C2B6E6F2B5A7A2F...</td>\n",
       "      <td>2019/4/19 3:39:28</td>\n",
       "      <td>0</td>\n",
       "      <td>17795406683</td>\n",
       "      <td>马智林</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>54387776352B634254763157714B677637642F74335259...</td>\n",
       "      <td>2019/4/20 4:32:31</td>\n",
       "      <td>0</td>\n",
       "      <td>17395065415</td>\n",
       "      <td>牛永鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6836315461616431666767417331686D4D384D48482F4D...</td>\n",
       "      <td>2019/4/21 3:26:55</td>\n",
       "      <td>0</td>\n",
       "      <td>17711848033</td>\n",
       "      <td>陈文新</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7645433731724E78494A42612B6A7361685248772B7345...</td>\n",
       "      <td>2019/4/20 9:45:09</td>\n",
       "      <td>0</td>\n",
       "      <td>18995421118</td>\n",
       "      <td>郭振民</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4D487A57514D35714F51796B784E722B2B6F665363307A...</td>\n",
       "      <td>2019/4/20 7:14:23</td>\n",
       "      <td>0</td>\n",
       "      <td>18995055516</td>\n",
       "      <td>钟兴国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>6850444975523668786939683877416B6B494636695357...</td>\n",
       "      <td>2019/4/21 6:26:34</td>\n",
       "      <td>0</td>\n",
       "      <td>18161630046</td>\n",
       "      <td>马学梅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7A4F476D505662487642383462382B2F7151516152394F...</td>\n",
       "      <td>2019/4/18 11:13:32</td>\n",
       "      <td>0</td>\n",
       "      <td>18161601119</td>\n",
       "      <td>马洪军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>6D4C5A584F5562504C726D567A7243354247527A7A7441...</td>\n",
       "      <td>2019/4/20 9:44:26</td>\n",
       "      <td>0</td>\n",
       "      <td>17395098213</td>\n",
       "      <td>崔春</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4E32346A746D454E5330307842743268514873394D4E50...</td>\n",
       "      <td>2019/4/19 9:34:09</td>\n",
       "      <td>0</td>\n",
       "      <td>18909536501</td>\n",
       "      <td>朱王东</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4448525267484D667261534235743930462B2B79504A36...</td>\n",
       "      <td>2019/4/20 6:10:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18109566662</td>\n",
       "      <td>韩磊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2B5841667A34727A364F334C4454726C32574B52367571...</td>\n",
       "      <td>2019/4/20 9:01:33</td>\n",
       "      <td>0</td>\n",
       "      <td>15379545577</td>\n",
       "      <td>郑腾</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>7746673868362F686A68494B6A6A45676B64416A656F4A...</td>\n",
       "      <td>2019/4/21 2:06:09</td>\n",
       "      <td>0</td>\n",
       "      <td>17709532876</td>\n",
       "      <td>王海生</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5A70635A4A576349694159667950316A5332576B304E47...</td>\n",
       "      <td>2019/4/20 3:59:19</td>\n",
       "      <td>0</td>\n",
       "      <td>18169169492</td>\n",
       "      <td>徐艳芬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6E4E58716375423958384A2F4C62626270504478636C6D...</td>\n",
       "      <td>2019/4/19 4:52:36</td>\n",
       "      <td>0</td>\n",
       "      <td>13309541953</td>\n",
       "      <td>海小梅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6E4E5871637542395838497777396C4433345550785533...</td>\n",
       "      <td>2019/4/18 8:53:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18195421805</td>\n",
       "      <td>王翠琴</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>39384B2B517132437A423833397548454B76446D644D48...</td>\n",
       "      <td>2019/4/19 4:52:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18995049773</td>\n",
       "      <td>梁志德</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>594B7A676469787956397A3936734C59716D4272495A6F...</td>\n",
       "      <td>2019/4/20 3:10:24</td>\n",
       "      <td>0</td>\n",
       "      <td>18195462966</td>\n",
       "      <td>张云明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>45545942504A4748754D6D345058364862587547747856...</td>\n",
       "      <td>2019/4/19 9:45:22</td>\n",
       "      <td>0</td>\n",
       "      <td>18195302345</td>\n",
       "      <td>赵瑞清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2B5841667A34727A364F33484273584E7A6368694D7A66...</td>\n",
       "      <td>2019/4/19 6:38:45</td>\n",
       "      <td>0</td>\n",
       "      <td>18195492776</td>\n",
       "      <td>杨极桐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>4448525267484D66726154477565516433513042367275...</td>\n",
       "      <td>2019/4/19 2:48:03</td>\n",
       "      <td>0</td>\n",
       "      <td>15379555644</td>\n",
       "      <td>牛长智</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324906</th>\n",
       "      <td>45556E685656704230316A664634613861345679494250...</td>\n",
       "      <td>2019/1/11 6:45:56</td>\n",
       "      <td>0</td>\n",
       "      <td>18187645670</td>\n",
       "      <td>杨波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324907</th>\n",
       "      <td>4879617436375055536F78544C4F4C637151756E4A2F71...</td>\n",
       "      <td>2019/1/10 5:04:49</td>\n",
       "      <td>0</td>\n",
       "      <td>17732068018</td>\n",
       "      <td>杜永生</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324908</th>\n",
       "      <td>7A736C78735674534A2B554550344973637A744B523246...</td>\n",
       "      <td>2019/1/11 8:19:26</td>\n",
       "      <td>0</td>\n",
       "      <td>13339249515</td>\n",
       "      <td>洪霞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324909</th>\n",
       "      <td>6C50727A772B586D55524F7549335A4578643375524648...</td>\n",
       "      <td>2019/1/10 4:30:59</td>\n",
       "      <td>0</td>\n",
       "      <td>18958510444</td>\n",
       "      <td>周智敏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324910</th>\n",
       "      <td>334B74686D49546167373678326F7A3643637451785545...</td>\n",
       "      <td>2019/1/12 4:39:53</td>\n",
       "      <td>0</td>\n",
       "      <td>13310800070</td>\n",
       "      <td>罗胜神</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324911</th>\n",
       "      <td>366C722F4D62765A42467446784D453866793931725439...</td>\n",
       "      <td>2019/1/11 5:49:30</td>\n",
       "      <td>0</td>\n",
       "      <td>15354138683</td>\n",
       "      <td>饶家松</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324912</th>\n",
       "      <td>4B71565475772B4E42374F69513531594C61426266706A...</td>\n",
       "      <td>2019/1/10 9:27:54</td>\n",
       "      <td>0</td>\n",
       "      <td>13323198537</td>\n",
       "      <td>赵子侠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324913</th>\n",
       "      <td>48556859714D486F45675670627A6A5377516E78324E52...</td>\n",
       "      <td>2019/1/12 3:42:57</td>\n",
       "      <td>0</td>\n",
       "      <td>18058361100</td>\n",
       "      <td>倪立锦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324914</th>\n",
       "      <td>4A7751353650622F33344548412B64557853464665777A...</td>\n",
       "      <td>2019/1/11 2:09:15</td>\n",
       "      <td>0</td>\n",
       "      <td>17723178507</td>\n",
       "      <td>胡波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324915</th>\n",
       "      <td>70424870302F523738494668394D496744494941306A71...</td>\n",
       "      <td>2019/1/10 2:40:49</td>\n",
       "      <td>0</td>\n",
       "      <td>15327697730</td>\n",
       "      <td>陈娟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324916</th>\n",
       "      <td>796C2F2F7A51746D594D2F4A6D694D5578564D4A6E6952...</td>\n",
       "      <td>2019/1/10 8:45:48</td>\n",
       "      <td>0</td>\n",
       "      <td>18076566179</td>\n",
       "      <td>王华英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324917</th>\n",
       "      <td>6C4A44772B5A33724F702B57492F4244354B70376D6E7A...</td>\n",
       "      <td>2019/1/12 2:18:07</td>\n",
       "      <td>0</td>\n",
       "      <td>18925876925</td>\n",
       "      <td>蒋洪卫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324918</th>\n",
       "      <td>5477507071344B776E77476A6D42556D68312B674C5177...</td>\n",
       "      <td>2019/1/10 7:44:59</td>\n",
       "      <td>0</td>\n",
       "      <td>17705161318</td>\n",
       "      <td>盛爱华</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324919</th>\n",
       "      <td>5245774A4D31704A7636336C5336325674777355444137...</td>\n",
       "      <td>2019/1/11 1:00:41</td>\n",
       "      <td>0</td>\n",
       "      <td>18057665898</td>\n",
       "      <td>苏文建</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324920</th>\n",
       "      <td>46465368666B6E6A746634597469484F3468516D526B6B...</td>\n",
       "      <td>2019/1/10 9:34:06</td>\n",
       "      <td>0</td>\n",
       "      <td>18073520747</td>\n",
       "      <td>邓春花</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324921</th>\n",
       "      <td>536269416B6E2B326F6E3677506D414D2F493377664F6B...</td>\n",
       "      <td>2019/1/10 7:41:11</td>\n",
       "      <td>0</td>\n",
       "      <td>18185769817</td>\n",
       "      <td>邓仕军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324922</th>\n",
       "      <td>35345761574D2F565670474D78344F586158477361672F...</td>\n",
       "      <td>2019/1/10 3:31:31</td>\n",
       "      <td>0</td>\n",
       "      <td>18190600591</td>\n",
       "      <td>肖鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324923</th>\n",
       "      <td>7A30385249495848686B4A2B737741537A547648696878...</td>\n",
       "      <td>2019/1/10 4:09:12</td>\n",
       "      <td>0</td>\n",
       "      <td>18100342031</td>\n",
       "      <td>王宇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324924</th>\n",
       "      <td>30466D594766766E764270374E6A66366554476F316A44...</td>\n",
       "      <td>2019/1/10 3:22:31</td>\n",
       "      <td>0</td>\n",
       "      <td>15378635378</td>\n",
       "      <td>陈伯全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324925</th>\n",
       "      <td>555769316E7230394633694A647A634D3334716B583154...</td>\n",
       "      <td>2019/1/10 8:56:16</td>\n",
       "      <td>0</td>\n",
       "      <td>18947102658</td>\n",
       "      <td>魏光复</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324926</th>\n",
       "      <td>4C6F61794544366F4A75413449483552486848546C3137...</td>\n",
       "      <td>2019/1/10 4:59:15</td>\n",
       "      <td>0</td>\n",
       "      <td>18188298382</td>\n",
       "      <td>崔勇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324927</th>\n",
       "      <td>72536246452F56696E4346585862617A4F553645366B56...</td>\n",
       "      <td>2019/1/10 7:36:03</td>\n",
       "      <td>0</td>\n",
       "      <td>13322021056</td>\n",
       "      <td>唐丽敏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324928</th>\n",
       "      <td>766A7568545A507736344971536D5A3036792B52445644...</td>\n",
       "      <td>2019/1/10 5:53:16</td>\n",
       "      <td>0</td>\n",
       "      <td>17704881388</td>\n",
       "      <td>孙涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324929</th>\n",
       "      <td>6C50727A772B586D55524E516357327334546F5A747142...</td>\n",
       "      <td>2019/1/11 8:32:50</td>\n",
       "      <td>0</td>\n",
       "      <td>18968593768</td>\n",
       "      <td>王辉军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324930</th>\n",
       "      <td>30454634376673336E47534541555A6C71345574476F68...</td>\n",
       "      <td>2019/1/10 6:28:55</td>\n",
       "      <td>0</td>\n",
       "      <td>15381022555</td>\n",
       "      <td>戴晓晓</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324931</th>\n",
       "      <td>51437968504C324D304F4C75373561396D2B4836724F64...</td>\n",
       "      <td>2019/1/12 1:10:10</td>\n",
       "      <td>0</td>\n",
       "      <td>15329116529</td>\n",
       "      <td>曹凤燕</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324932</th>\n",
       "      <td>734F565462626F7A524434626965567A45474668356433...</td>\n",
       "      <td>2019/1/10 2:13:26</td>\n",
       "      <td>0</td>\n",
       "      <td>15364000699</td>\n",
       "      <td>周十路</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324933</th>\n",
       "      <td>463175564A78634976756A6D43644B6632714C77417946...</td>\n",
       "      <td>2019/1/11 6:01:19</td>\n",
       "      <td>0</td>\n",
       "      <td>13330590239</td>\n",
       "      <td>黄绍田</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324934</th>\n",
       "      <td>6F79576A71616238552B782B36377A5037656B79524B53...</td>\n",
       "      <td>2019/1/10 5:19:27</td>\n",
       "      <td>0</td>\n",
       "      <td>18094805515</td>\n",
       "      <td>田小兵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324935</th>\n",
       "      <td>645A37523357636F73486C4F4C626D6F56757A714C7854...</td>\n",
       "      <td>2019/1/10 9:09:48</td>\n",
       "      <td>0</td>\n",
       "      <td>18905489778</td>\n",
       "      <td>颜廷俭</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>324936 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           cert_no_cipher       complete_time  \\\n",
       "0       6E466B36515853576E66786A4A68693835627565534E74...   2019/4/18 2:24:59   \n",
       "1       326C746C693562662B574B466B6D377048394B4D467855...   2019/4/16 3:43:56   \n",
       "2       326C746C693562662B574B4B61654154623141686B3931...   2019/4/16 7:20:52   \n",
       "3       4D487A57514D35714F517A563547534B4B5130376D5636...   2019/4/15 6:43:27   \n",
       "4       2B5841667A34727A364F33786C7752573844667273547A...   2019/4/16 1:50:12   \n",
       "5       45545942504A4748754D6E6356756277576F69375A6271...   2019/4/16 9:52:37   \n",
       "6       676C4B564E2B32676A4C4C6931743048315369345A4D76...   2019/4/17 4:37:42   \n",
       "7       764B443842704B766A6C4A3865666F314C45786E42736B...  2019/4/16 10:27:53   \n",
       "8       5369526D63734C445375436E59694877314E3934625A50...   2019/4/16 4:42:28   \n",
       "9       5369526D63734C44537543327965755839347661455177...  2019/4/19 11:04:43   \n",
       "10      764B443842704B766A6C4B614356384C2B6E6F2B5A7A2F...   2019/4/19 3:39:28   \n",
       "11      54387776352B634254763157714B677637642F74335259...   2019/4/20 4:32:31   \n",
       "12      6836315461616431666767417331686D4D384D48482F4D...   2019/4/21 3:26:55   \n",
       "13      7645433731724E78494A42612B6A7361685248772B7345...   2019/4/20 9:45:09   \n",
       "14      4D487A57514D35714F51796B784E722B2B6F665363307A...   2019/4/20 7:14:23   \n",
       "15      6850444975523668786939683877416B6B494636695357...   2019/4/21 6:26:34   \n",
       "16      7A4F476D505662487642383462382B2F7151516152394F...  2019/4/18 11:13:32   \n",
       "17      6D4C5A584F5562504C726D567A7243354247527A7A7441...   2019/4/20 9:44:26   \n",
       "18      4E32346A746D454E5330307842743268514873394D4E50...   2019/4/19 9:34:09   \n",
       "19      4448525267484D667261534235743930462B2B79504A36...   2019/4/20 6:10:39   \n",
       "20      2B5841667A34727A364F334C4454726C32574B52367571...   2019/4/20 9:01:33   \n",
       "21      7746673868362F686A68494B6A6A45676B64416A656F4A...   2019/4/21 2:06:09   \n",
       "22      5A70635A4A576349694159667950316A5332576B304E47...   2019/4/20 3:59:19   \n",
       "23      6E4E58716375423958384A2F4C62626270504478636C6D...   2019/4/19 4:52:36   \n",
       "24      6E4E5871637542395838497777396C4433345550785533...   2019/4/18 8:53:28   \n",
       "25      39384B2B517132437A423833397548454B76446D644D48...   2019/4/19 4:52:39   \n",
       "26      594B7A676469787956397A3936734C59716D4272495A6F...   2019/4/20 3:10:24   \n",
       "27      45545942504A4748754D6D345058364862587547747856...   2019/4/19 9:45:22   \n",
       "28      2B5841667A34727A364F33484273584E7A6368694D7A66...   2019/4/19 6:38:45   \n",
       "29      4448525267484D66726154477565516433513042367275...   2019/4/19 2:48:03   \n",
       "...                                                   ...                 ...   \n",
       "324906  45556E685656704230316A664634613861345679494250...   2019/1/11 6:45:56   \n",
       "324907  4879617436375055536F78544C4F4C637151756E4A2F71...   2019/1/10 5:04:49   \n",
       "324908  7A736C78735674534A2B554550344973637A744B523246...   2019/1/11 8:19:26   \n",
       "324909  6C50727A772B586D55524F7549335A4578643375524648...   2019/1/10 4:30:59   \n",
       "324910  334B74686D49546167373678326F7A3643637451785545...   2019/1/12 4:39:53   \n",
       "324911  366C722F4D62765A42467446784D453866793931725439...   2019/1/11 5:49:30   \n",
       "324912  4B71565475772B4E42374F69513531594C61426266706A...   2019/1/10 9:27:54   \n",
       "324913  48556859714D486F45675670627A6A5377516E78324E52...   2019/1/12 3:42:57   \n",
       "324914  4A7751353650622F33344548412B64557853464665777A...   2019/1/11 2:09:15   \n",
       "324915  70424870302F523738494668394D496744494941306A71...   2019/1/10 2:40:49   \n",
       "324916  796C2F2F7A51746D594D2F4A6D694D5578564D4A6E6952...   2019/1/10 8:45:48   \n",
       "324917  6C4A44772B5A33724F702B57492F4244354B70376D6E7A...   2019/1/12 2:18:07   \n",
       "324918  5477507071344B776E77476A6D42556D68312B674C5177...   2019/1/10 7:44:59   \n",
       "324919  5245774A4D31704A7636336C5336325674777355444137...   2019/1/11 1:00:41   \n",
       "324920  46465368666B6E6A746634597469484F3468516D526B6B...   2019/1/10 9:34:06   \n",
       "324921  536269416B6E2B326F6E3677506D414D2F493377664F6B...   2019/1/10 7:41:11   \n",
       "324922  35345761574D2F565670474D78344F586158477361672F...   2019/1/10 3:31:31   \n",
       "324923  7A30385249495848686B4A2B737741537A547648696878...   2019/1/10 4:09:12   \n",
       "324924  30466D594766766E764270374E6A66366554476F316A44...   2019/1/10 3:22:31   \n",
       "324925  555769316E7230394633694A647A634D3334716B583154...   2019/1/10 8:56:16   \n",
       "324926  4C6F61794544366F4A75413449483552486848546C3137...   2019/1/10 4:59:15   \n",
       "324927  72536246452F56696E4346585862617A4F553645366B56...   2019/1/10 7:36:03   \n",
       "324928  766A7568545A507736344971536D5A3036792B52445644...   2019/1/10 5:53:16   \n",
       "324929  6C50727A772B586D55524E516357327334546F5A747142...   2019/1/11 8:32:50   \n",
       "324930  30454634376673336E47534541555A6C71345574476F68...   2019/1/10 6:28:55   \n",
       "324931  51437968504C324D304F4C75373561396D2B4836724F64...   2019/1/12 1:10:10   \n",
       "324932  734F565462626F7A524434626965567A45474668356433...   2019/1/10 2:13:26   \n",
       "324933  463175564A78634976756A6D43644B6632714C77417946...   2019/1/11 6:01:19   \n",
       "324934  6F79576A71616238552B782B36377A5037656B79524B53...   2019/1/10 5:19:27   \n",
       "324935  645A37523357636F73486C4F4C626D6F56757A714C7854...   2019/1/10 9:09:48   \n",
       "\n",
       "        is_overdue   mobile_nbr user_name  \n",
       "0                0  15378923256        李瑞  \n",
       "1                0  15378935690       徐淑红  \n",
       "2                0  18095193521       宋鹏明  \n",
       "3                0  13389520088        方超  \n",
       "4                0  17709596636       王继权  \n",
       "5                0  18161618494       杨忠良  \n",
       "6                0  18195306761        马林  \n",
       "7                0  18095453387       朱国斌  \n",
       "8                0  18095276294       吴自斌  \n",
       "9                0  15378930527       伍少波  \n",
       "10               0  17795406683       马智林  \n",
       "11               0  17395065415       牛永鑫  \n",
       "12               0  17711848033       陈文新  \n",
       "13               0  18995421118       郭振民  \n",
       "14               0  18995055516       钟兴国  \n",
       "15               0  18161630046       马学梅  \n",
       "16               0  18161601119       马洪军  \n",
       "17               0  17395098213        崔春  \n",
       "18               0  18909536501       朱王东  \n",
       "19               0  18109566662        韩磊  \n",
       "20               0  15379545577        郑腾  \n",
       "21               0  17709532876       王海生  \n",
       "22               0  18169169492       徐艳芬  \n",
       "23               0  13309541953       海小梅  \n",
       "24               0  18195421805       王翠琴  \n",
       "25               0  18995049773       梁志德  \n",
       "26               0  18195462966       张云明  \n",
       "27               0  18195302345       赵瑞清  \n",
       "28               0  18195492776       杨极桐  \n",
       "29               0  15379555644       牛长智  \n",
       "...            ...          ...       ...  \n",
       "324906           0  18187645670        杨波  \n",
       "324907           0  17732068018       杜永生  \n",
       "324908           0  13339249515        洪霞  \n",
       "324909           0  18958510444       周智敏  \n",
       "324910           0  13310800070       罗胜神  \n",
       "324911           0  15354138683       饶家松  \n",
       "324912           0  13323198537       赵子侠  \n",
       "324913           0  18058361100       倪立锦  \n",
       "324914           0  17723178507        胡波  \n",
       "324915           0  15327697730        陈娟  \n",
       "324916           0  18076566179       王华英  \n",
       "324917           0  18925876925       蒋洪卫  \n",
       "324918           0  17705161318       盛爱华  \n",
       "324919           0  18057665898       苏文建  \n",
       "324920           0  18073520747       邓春花  \n",
       "324921           0  18185769817       邓仕军  \n",
       "324922           0  18190600591        肖鑫  \n",
       "324923           0  18100342031        王宇  \n",
       "324924           0  15378635378       陈伯全  \n",
       "324925           0  18947102658       魏光复  \n",
       "324926           0  18188298382        崔勇  \n",
       "324927           0  13322021056       唐丽敏  \n",
       "324928           0  17704881388        孙涛  \n",
       "324929           0  18968593768       王辉军  \n",
       "324930           0  15381022555       戴晓晓  \n",
       "324931           0  15329116529       曹凤燕  \n",
       "324932           0  15364000699       周十路  \n",
       "324933           0  13330590239       黄绍田  \n",
       "324934           0  18094805515       田小兵  \n",
       "324935           0  18905489778       颜廷俭  \n",
       "\n",
       "[324936 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.drop(columns='记录数',inplace=True)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:08:27.144103Z",
     "start_time": "2019-11-14T10:08:27.100220Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cert_no_cipher</th>\n",
       "      <th>complete_time</th>\n",
       "      <th>is_overdue</th>\n",
       "      <th>mobile_nbr</th>\n",
       "      <th>user_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1243</th>\n",
       "      <td>764B443842704B766A6C494C704838796D6C6179315A4D...</td>\n",
       "      <td>2019/4/24 3:10:27</td>\n",
       "      <td>1</td>\n",
       "      <td>18995174433</td>\n",
       "      <td>杨国俊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2147</th>\n",
       "      <td>594B7A6764697879563979595A446C4C4D4C4B38416247...</td>\n",
       "      <td>2019/4/19 8:33:27</td>\n",
       "      <td>1</td>\n",
       "      <td>18161531981</td>\n",
       "      <td>马宏花</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2155</th>\n",
       "      <td>676C4B564E2B32676A4C4B67724F42325A75626D583357...</td>\n",
       "      <td>2019/4/19 7:30:03</td>\n",
       "      <td>1</td>\n",
       "      <td>18995399588</td>\n",
       "      <td>杨海涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2623</th>\n",
       "      <td>75717845662F50503646436F74496F4E515967564A6F66...</td>\n",
       "      <td>2019/4/26 7:50:14</td>\n",
       "      <td>1</td>\n",
       "      <td>18963396917</td>\n",
       "      <td>徐军学</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2629</th>\n",
       "      <td>676C4B564E2B32676A4C4C3644554552457355442F6D4C...</td>\n",
       "      <td>2019/4/25 5:10:32</td>\n",
       "      <td>1</td>\n",
       "      <td>18095356014</td>\n",
       "      <td>马园</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2725</th>\n",
       "      <td>6E4E58716375423958384B79375679465A496B376C3346...</td>\n",
       "      <td>2019/4/4 4:05:17</td>\n",
       "      <td>1</td>\n",
       "      <td>18152581333</td>\n",
       "      <td>张聚珍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>594B7A676469787956397A7553345A5537684D6D717772...</td>\n",
       "      <td>2019/4/10 8:07:57</td>\n",
       "      <td>1</td>\n",
       "      <td>13369555323</td>\n",
       "      <td>田虎</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2810</th>\n",
       "      <td>7663714970715A774A34464D5347344468736A68423541...</td>\n",
       "      <td>2019/4/12 8:51:54</td>\n",
       "      <td>1</td>\n",
       "      <td>18152341314</td>\n",
       "      <td>袁崇明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2975</th>\n",
       "      <td>646745777859454A73335A2F73453467306A46746D7331...</td>\n",
       "      <td>2019/4/19 7:47:07</td>\n",
       "      <td>1</td>\n",
       "      <td>18169099309</td>\n",
       "      <td>王雷雷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3189</th>\n",
       "      <td>4752313756736B6331797850667638526763636F2B432B...</td>\n",
       "      <td>2019/4/10 9:26:16</td>\n",
       "      <td>1</td>\n",
       "      <td>17709516172</td>\n",
       "      <td>白其武</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3535</th>\n",
       "      <td>764B443842704B766A6C49586E6D365255726248335573...</td>\n",
       "      <td>2019/4/9 4:03:11</td>\n",
       "      <td>1</td>\n",
       "      <td>18995444086</td>\n",
       "      <td>穆光怀</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4032</th>\n",
       "      <td>5369526D63734C445375424C37563768466B4762776E4B...</td>\n",
       "      <td>2019/4/19 2:21:45</td>\n",
       "      <td>1</td>\n",
       "      <td>18995090755</td>\n",
       "      <td>毛军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4112</th>\n",
       "      <td>65306272356D4A745554463159554B56636E362F336334...</td>\n",
       "      <td>2019/4/4 10:01:20</td>\n",
       "      <td>1</td>\n",
       "      <td>18995303677</td>\n",
       "      <td>尚金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4337</th>\n",
       "      <td>654F376B4F59434B39657044376B4F4E596E5037516E59...</td>\n",
       "      <td>2019/4/8 4:00:31</td>\n",
       "      <td>1</td>\n",
       "      <td>18109596293</td>\n",
       "      <td>薛钧泽</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5313</th>\n",
       "      <td>33534B57454F6A484351707750456E3354496751464D62...</td>\n",
       "      <td>2019/4/18 4:39:45</td>\n",
       "      <td>1</td>\n",
       "      <td>18047115595</td>\n",
       "      <td>张玉龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5359</th>\n",
       "      <td>7A4F476D5056624876422B67736B43522B377936796D32...</td>\n",
       "      <td>2019/4/12 8:18:04</td>\n",
       "      <td>1</td>\n",
       "      <td>18995315300</td>\n",
       "      <td>魏建成</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5572</th>\n",
       "      <td>6E4E58716375423958384A6B387758472F424C52387331...</td>\n",
       "      <td>2019/4/26 5:51:31</td>\n",
       "      <td>1</td>\n",
       "      <td>18152555112</td>\n",
       "      <td>王耀顺</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5761</th>\n",
       "      <td>427154436877702B46617865527A4445346D44624C3348...</td>\n",
       "      <td>2019/4/11 2:05:33</td>\n",
       "      <td>1</td>\n",
       "      <td>18995127295</td>\n",
       "      <td>王晓中</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5765</th>\n",
       "      <td>4E4D53774446757478334C656554393279305658695962...</td>\n",
       "      <td>2019/4/11 11:07:23</td>\n",
       "      <td>1</td>\n",
       "      <td>17795521785</td>\n",
       "      <td>曹志余</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5981</th>\n",
       "      <td>7746673868362F686A684B50614239754D2B7A39512B51...</td>\n",
       "      <td>2019/4/3 10:47:07</td>\n",
       "      <td>1</td>\n",
       "      <td>13389570321</td>\n",
       "      <td>冯利秀</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6158</th>\n",
       "      <td>6E466B36515853576E66794F34464D4241426B506E5A55...</td>\n",
       "      <td>2019/4/17 11:08:30</td>\n",
       "      <td>1</td>\n",
       "      <td>18152511552</td>\n",
       "      <td>吴江</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6206</th>\n",
       "      <td>77316E4B7533737A565A306F4934694A41436337714852...</td>\n",
       "      <td>2019/4/25 9:21:52</td>\n",
       "      <td>1</td>\n",
       "      <td>18152374057</td>\n",
       "      <td>罗晓刚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6273</th>\n",
       "      <td>6E4E58716375423958384A6A6B5A686938733155456F54...</td>\n",
       "      <td>2019/4/26 8:26:43</td>\n",
       "      <td>1</td>\n",
       "      <td>15379668966</td>\n",
       "      <td>何桂珍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6286</th>\n",
       "      <td>625250346A3057636F67613731424456792B42626C7A30...</td>\n",
       "      <td>2019/4/30 5:16:32</td>\n",
       "      <td>1</td>\n",
       "      <td>18095279128</td>\n",
       "      <td>李晶晶</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6385</th>\n",
       "      <td>2B5841667A34727A364F33474A476F762F6442634B4D4B...</td>\n",
       "      <td>2019/4/16 4:22:11</td>\n",
       "      <td>1</td>\n",
       "      <td>15379667999</td>\n",
       "      <td>佘文伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6516</th>\n",
       "      <td>3351574D744850543342647670356B6A31626E69716B51...</td>\n",
       "      <td>2019/5/17 8:01:06</td>\n",
       "      <td>1</td>\n",
       "      <td>18189056636</td>\n",
       "      <td>扎西次仁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6608</th>\n",
       "      <td>594E77686552354F6444676B37695257664E455162514B...</td>\n",
       "      <td>2019/5/4 4:32:14</td>\n",
       "      <td>1</td>\n",
       "      <td>18189957766</td>\n",
       "      <td>次仁拉措</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6802</th>\n",
       "      <td>416D6434716B61305037642F3234783939735738512F56...</td>\n",
       "      <td>2019/5/10 5:41:01</td>\n",
       "      <td>1</td>\n",
       "      <td>18143224996</td>\n",
       "      <td>洛桑伦珠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6926</th>\n",
       "      <td>4A75564F573074634F374B5530384C537968465564695A...</td>\n",
       "      <td>2019/5/8 5:58:59</td>\n",
       "      <td>1</td>\n",
       "      <td>17306355521</td>\n",
       "      <td>苏本超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7417</th>\n",
       "      <td>7A62586E4E702B2B386650326D784F3142686248713576...</td>\n",
       "      <td>2019/3/1 4:39:15</td>\n",
       "      <td>1</td>\n",
       "      <td>18089532244</td>\n",
       "      <td>张仕俊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320877</th>\n",
       "      <td>63532F2B4A4A7531392B46467676494A4677474D777162...</td>\n",
       "      <td>2019/1/27 4:31:04</td>\n",
       "      <td>1</td>\n",
       "      <td>13320642130</td>\n",
       "      <td>吴军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320945</th>\n",
       "      <td>734C6453723264563574502F42794D764B736F4B656973...</td>\n",
       "      <td>2019/1/27 5:19:14</td>\n",
       "      <td>1</td>\n",
       "      <td>18005707088</td>\n",
       "      <td>王素军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321021</th>\n",
       "      <td>315971446939746C6D4C3448563348734731335171676E...</td>\n",
       "      <td>2019/1/27 2:59:40</td>\n",
       "      <td>1</td>\n",
       "      <td>17764908905</td>\n",
       "      <td>黄明英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321038</th>\n",
       "      <td>48416656744C624753697337566F31514338426853736B...</td>\n",
       "      <td>2019/1/26 6:21:19</td>\n",
       "      <td>1</td>\n",
       "      <td>17763941351</td>\n",
       "      <td>胡亚贵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321109</th>\n",
       "      <td>62737A644772564F704C765570573078756C4450386561...</td>\n",
       "      <td>2019/1/26 6:47:42</td>\n",
       "      <td>1</td>\n",
       "      <td>13303483112</td>\n",
       "      <td>王兴坤</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321319</th>\n",
       "      <td>6668316677655959736B2B69503449426C427971705031...</td>\n",
       "      <td>2019/1/13 7:22:44</td>\n",
       "      <td>1</td>\n",
       "      <td>18968553952</td>\n",
       "      <td>庞建民</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321363</th>\n",
       "      <td>566B7274526334456E4E45764E2F4B303941306E354474...</td>\n",
       "      <td>2019/1/13 2:09:56</td>\n",
       "      <td>1</td>\n",
       "      <td>17705987397</td>\n",
       "      <td>邓茂官</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321459</th>\n",
       "      <td>387A4D647135543944736431473277326C396C785A6176...</td>\n",
       "      <td>2019/1/15 8:09:45</td>\n",
       "      <td>1</td>\n",
       "      <td>13305765221</td>\n",
       "      <td>金良江</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321494</th>\n",
       "      <td>416A54345A374C6A78756A7766694353767053436F6F63...</td>\n",
       "      <td>2019/1/14 7:05:07</td>\n",
       "      <td>1</td>\n",
       "      <td>17777218395</td>\n",
       "      <td>杨友高</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321550</th>\n",
       "      <td>4E6F4C715132774B6847746C513335334B3754464F5A52...</td>\n",
       "      <td>2019/1/14 8:41:19</td>\n",
       "      <td>1</td>\n",
       "      <td>15393991380</td>\n",
       "      <td>巴艳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321596</th>\n",
       "      <td>53615A35664D3039333345516542396A75716C6A47514C...</td>\n",
       "      <td>2019/1/14 6:25:35</td>\n",
       "      <td>1</td>\n",
       "      <td>15378639062</td>\n",
       "      <td>卢芬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321770</th>\n",
       "      <td>536269416B6E2B326F6E345A7678446350666778386D31...</td>\n",
       "      <td>2019/1/8 5:10:13</td>\n",
       "      <td>1</td>\n",
       "      <td>18158331376</td>\n",
       "      <td>龙银全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322361</th>\n",
       "      <td>6854516C662F6748536C474D62496A7A375A2F556F5271...</td>\n",
       "      <td>2019/1/24 5:56:00</td>\n",
       "      <td>1</td>\n",
       "      <td>13315422777</td>\n",
       "      <td>陈保江</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322375</th>\n",
       "      <td>50594452554A502B343038346D65756864544F45743876...</td>\n",
       "      <td>2019/1/24 7:02:15</td>\n",
       "      <td>1</td>\n",
       "      <td>17783728877</td>\n",
       "      <td>何兵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322913</th>\n",
       "      <td>55706E7A53564338694D45457447454969514F47493757...</td>\n",
       "      <td>2019/1/23 8:07:35</td>\n",
       "      <td>1</td>\n",
       "      <td>13325128199</td>\n",
       "      <td>袁玉国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323090</th>\n",
       "      <td>2B787957494C39616448786E6C61594346726258653043...</td>\n",
       "      <td>2019/1/12 6:55:38</td>\n",
       "      <td>1</td>\n",
       "      <td>15349156600</td>\n",
       "      <td>孙启哲</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323195</th>\n",
       "      <td>4C6259414D45305A72446D6E324D675536514274335547...</td>\n",
       "      <td>2019/1/13 4:56:14</td>\n",
       "      <td>1</td>\n",
       "      <td>18909515060</td>\n",
       "      <td>韩莉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323233</th>\n",
       "      <td>552B3766385351717272722B7348774E664D754F626E6F...</td>\n",
       "      <td>2019/1/13 6:36:44</td>\n",
       "      <td>1</td>\n",
       "      <td>18072985702</td>\n",
       "      <td>周子高</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323462</th>\n",
       "      <td>48556859714D486F4567567031434A6C7337646B484443...</td>\n",
       "      <td>2019/1/8 8:00:34</td>\n",
       "      <td>1</td>\n",
       "      <td>18958761655</td>\n",
       "      <td>夏孟校</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323574</th>\n",
       "      <td>39332F527143654C4C324535466F6B56747974374B6D6C...</td>\n",
       "      <td>2019/1/10 8:17:44</td>\n",
       "      <td>1</td>\n",
       "      <td>15390892146</td>\n",
       "      <td>万其亮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323809</th>\n",
       "      <td>6A6F5766306D6A53562B564F314A6F3936497A484B7857...</td>\n",
       "      <td>2019/1/11 2:38:50</td>\n",
       "      <td>1</td>\n",
       "      <td>13315269839</td>\n",
       "      <td>颜晨旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324243</th>\n",
       "      <td>584D70754F784257354C514A597A546E72484D3075676C...</td>\n",
       "      <td>2019/1/13 9:25:45</td>\n",
       "      <td>1</td>\n",
       "      <td>18013276807</td>\n",
       "      <td>孙宗国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324285</th>\n",
       "      <td>76774F64747A324C6E576F5270794E6373746E41633445...</td>\n",
       "      <td>2019/1/13 11:26:07</td>\n",
       "      <td>1</td>\n",
       "      <td>17782830285</td>\n",
       "      <td>郑佩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324315</th>\n",
       "      <td>784758796555374C6C576B775A6B356E426D774B697172...</td>\n",
       "      <td>2019/1/14 3:37:02</td>\n",
       "      <td>1</td>\n",
       "      <td>18008585666</td>\n",
       "      <td>聂伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324322</th>\n",
       "      <td>4852573251626C653878475630347A624F486C52757A45...</td>\n",
       "      <td>2019/1/13 4:47:19</td>\n",
       "      <td>1</td>\n",
       "      <td>18997361277</td>\n",
       "      <td>扎西江才</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324521</th>\n",
       "      <td>3476612F5A31506F63765143596C6C34743872657A4545...</td>\n",
       "      <td>2019/1/10 8:03:23</td>\n",
       "      <td>1</td>\n",
       "      <td>18191591905</td>\n",
       "      <td>李龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324531</th>\n",
       "      <td>584D70754F784257354C51383450664476684974375757...</td>\n",
       "      <td>2019/1/12 3:20:27</td>\n",
       "      <td>1</td>\n",
       "      <td>17763046830</td>\n",
       "      <td>江培军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324608</th>\n",
       "      <td>354B67326A3461586B76434F6A4B464A6463526E437741...</td>\n",
       "      <td>2019/1/11 7:46:33</td>\n",
       "      <td>1</td>\n",
       "      <td>17778822625</td>\n",
       "      <td>马艳涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324674</th>\n",
       "      <td>377967352B7A50745435664B78444E6C6E493359784968...</td>\n",
       "      <td>2019/1/11 7:26:17</td>\n",
       "      <td>1</td>\n",
       "      <td>18078700907</td>\n",
       "      <td>孔祥贵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324898</th>\n",
       "      <td>496C35334C677A524F383065774C6F68356F7143776747...</td>\n",
       "      <td>2019/1/11 5:44:03</td>\n",
       "      <td>1</td>\n",
       "      <td>15343430200</td>\n",
       "      <td>王二牛</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2160 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           cert_no_cipher       complete_time  \\\n",
       "1243    764B443842704B766A6C494C704838796D6C6179315A4D...   2019/4/24 3:10:27   \n",
       "2147    594B7A6764697879563979595A446C4C4D4C4B38416247...   2019/4/19 8:33:27   \n",
       "2155    676C4B564E2B32676A4C4B67724F42325A75626D583357...   2019/4/19 7:30:03   \n",
       "2623    75717845662F50503646436F74496F4E515967564A6F66...   2019/4/26 7:50:14   \n",
       "2629    676C4B564E2B32676A4C4C3644554552457355442F6D4C...   2019/4/25 5:10:32   \n",
       "2725    6E4E58716375423958384B79375679465A496B376C3346...    2019/4/4 4:05:17   \n",
       "2790    594B7A676469787956397A7553345A5537684D6D717772...   2019/4/10 8:07:57   \n",
       "2810    7663714970715A774A34464D5347344468736A68423541...   2019/4/12 8:51:54   \n",
       "2975    646745777859454A73335A2F73453467306A46746D7331...   2019/4/19 7:47:07   \n",
       "3189    4752313756736B6331797850667638526763636F2B432B...   2019/4/10 9:26:16   \n",
       "3535    764B443842704B766A6C49586E6D365255726248335573...    2019/4/9 4:03:11   \n",
       "4032    5369526D63734C445375424C37563768466B4762776E4B...   2019/4/19 2:21:45   \n",
       "4112    65306272356D4A745554463159554B56636E362F336334...   2019/4/4 10:01:20   \n",
       "4337    654F376B4F59434B39657044376B4F4E596E5037516E59...    2019/4/8 4:00:31   \n",
       "5313    33534B57454F6A484351707750456E3354496751464D62...   2019/4/18 4:39:45   \n",
       "5359    7A4F476D5056624876422B67736B43522B377936796D32...   2019/4/12 8:18:04   \n",
       "5572    6E4E58716375423958384A6B387758472F424C52387331...   2019/4/26 5:51:31   \n",
       "5761    427154436877702B46617865527A4445346D44624C3348...   2019/4/11 2:05:33   \n",
       "5765    4E4D53774446757478334C656554393279305658695962...  2019/4/11 11:07:23   \n",
       "5981    7746673868362F686A684B50614239754D2B7A39512B51...   2019/4/3 10:47:07   \n",
       "6158    6E466B36515853576E66794F34464D4241426B506E5A55...  2019/4/17 11:08:30   \n",
       "6206    77316E4B7533737A565A306F4934694A41436337714852...   2019/4/25 9:21:52   \n",
       "6273    6E4E58716375423958384A6A6B5A686938733155456F54...   2019/4/26 8:26:43   \n",
       "6286    625250346A3057636F67613731424456792B42626C7A30...   2019/4/30 5:16:32   \n",
       "6385    2B5841667A34727A364F33474A476F762F6442634B4D4B...   2019/4/16 4:22:11   \n",
       "6516    3351574D744850543342647670356B6A31626E69716B51...   2019/5/17 8:01:06   \n",
       "6608    594E77686552354F6444676B37695257664E455162514B...    2019/5/4 4:32:14   \n",
       "6802    416D6434716B61305037642F3234783939735738512F56...   2019/5/10 5:41:01   \n",
       "6926    4A75564F573074634F374B5530384C537968465564695A...    2019/5/8 5:58:59   \n",
       "7417    7A62586E4E702B2B386650326D784F3142686248713576...    2019/3/1 4:39:15   \n",
       "...                                                   ...                 ...   \n",
       "320877  63532F2B4A4A7531392B46467676494A4677474D777162...   2019/1/27 4:31:04   \n",
       "320945  734C6453723264563574502F42794D764B736F4B656973...   2019/1/27 5:19:14   \n",
       "321021  315971446939746C6D4C3448563348734731335171676E...   2019/1/27 2:59:40   \n",
       "321038  48416656744C624753697337566F31514338426853736B...   2019/1/26 6:21:19   \n",
       "321109  62737A644772564F704C765570573078756C4450386561...   2019/1/26 6:47:42   \n",
       "321319  6668316677655959736B2B69503449426C427971705031...   2019/1/13 7:22:44   \n",
       "321363  566B7274526334456E4E45764E2F4B303941306E354474...   2019/1/13 2:09:56   \n",
       "321459  387A4D647135543944736431473277326C396C785A6176...   2019/1/15 8:09:45   \n",
       "321494  416A54345A374C6A78756A7766694353767053436F6F63...   2019/1/14 7:05:07   \n",
       "321550  4E6F4C715132774B6847746C513335334B3754464F5A52...   2019/1/14 8:41:19   \n",
       "321596  53615A35664D3039333345516542396A75716C6A47514C...   2019/1/14 6:25:35   \n",
       "321770  536269416B6E2B326F6E345A7678446350666778386D31...    2019/1/8 5:10:13   \n",
       "322361  6854516C662F6748536C474D62496A7A375A2F556F5271...   2019/1/24 5:56:00   \n",
       "322375  50594452554A502B343038346D65756864544F45743876...   2019/1/24 7:02:15   \n",
       "322913  55706E7A53564338694D45457447454969514F47493757...   2019/1/23 8:07:35   \n",
       "323090  2B787957494C39616448786E6C61594346726258653043...   2019/1/12 6:55:38   \n",
       "323195  4C6259414D45305A72446D6E324D675536514274335547...   2019/1/13 4:56:14   \n",
       "323233  552B3766385351717272722B7348774E664D754F626E6F...   2019/1/13 6:36:44   \n",
       "323462  48556859714D486F4567567031434A6C7337646B484443...    2019/1/8 8:00:34   \n",
       "323574  39332F527143654C4C324535466F6B56747974374B6D6C...   2019/1/10 8:17:44   \n",
       "323809  6A6F5766306D6A53562B564F314A6F3936497A484B7857...   2019/1/11 2:38:50   \n",
       "324243  584D70754F784257354C514A597A546E72484D3075676C...   2019/1/13 9:25:45   \n",
       "324285  76774F64747A324C6E576F5270794E6373746E41633445...  2019/1/13 11:26:07   \n",
       "324315  784758796555374C6C576B775A6B356E426D774B697172...   2019/1/14 3:37:02   \n",
       "324322  4852573251626C653878475630347A624F486C52757A45...   2019/1/13 4:47:19   \n",
       "324521  3476612F5A31506F63765143596C6C34743872657A4545...   2019/1/10 8:03:23   \n",
       "324531  584D70754F784257354C51383450664476684974375757...   2019/1/12 3:20:27   \n",
       "324608  354B67326A3461586B76434F6A4B464A6463526E437741...   2019/1/11 7:46:33   \n",
       "324674  377967352B7A50745435664B78444E6C6E493359784968...   2019/1/11 7:26:17   \n",
       "324898  496C35334C677A524F383065774C6F68356F7143776747...   2019/1/11 5:44:03   \n",
       "\n",
       "        is_overdue   mobile_nbr user_name  \n",
       "1243             1  18995174433       杨国俊  \n",
       "2147             1  18161531981       马宏花  \n",
       "2155             1  18995399588       杨海涛  \n",
       "2623             1  18963396917       徐军学  \n",
       "2629             1  18095356014        马园  \n",
       "2725             1  18152581333       张聚珍  \n",
       "2790             1  13369555323        田虎  \n",
       "2810             1  18152341314       袁崇明  \n",
       "2975             1  18169099309       王雷雷  \n",
       "3189             1  17709516172       白其武  \n",
       "3535             1  18995444086       穆光怀  \n",
       "4032             1  18995090755        毛军  \n",
       "4112             1  18995303677        尚金  \n",
       "4337             1  18109596293       薛钧泽  \n",
       "5313             1  18047115595       张玉龙  \n",
       "5359             1  18995315300       魏建成  \n",
       "5572             1  18152555112       王耀顺  \n",
       "5761             1  18995127295       王晓中  \n",
       "5765             1  17795521785       曹志余  \n",
       "5981             1  13389570321       冯利秀  \n",
       "6158             1  18152511552        吴江  \n",
       "6206             1  18152374057       罗晓刚  \n",
       "6273             1  15379668966       何桂珍  \n",
       "6286             1  18095279128       李晶晶  \n",
       "6385             1  15379667999       佘文伟  \n",
       "6516             1  18189056636      扎西次仁  \n",
       "6608             1  18189957766      次仁拉措  \n",
       "6802             1  18143224996      洛桑伦珠  \n",
       "6926             1  17306355521       苏本超  \n",
       "7417             1  18089532244       张仕俊  \n",
       "...            ...          ...       ...  \n",
       "320877           1  13320642130        吴军  \n",
       "320945           1  18005707088       王素军  \n",
       "321021           1  17764908905       黄明英  \n",
       "321038           1  17763941351       胡亚贵  \n",
       "321109           1  13303483112       王兴坤  \n",
       "321319           1  18968553952       庞建民  \n",
       "321363           1  17705987397       邓茂官  \n",
       "321459           1  13305765221       金良江  \n",
       "321494           1  17777218395       杨友高  \n",
       "321550           1  15393991380        巴艳  \n",
       "321596           1  15378639062        卢芬  \n",
       "321770           1  18158331376       龙银全  \n",
       "322361           1  13315422777       陈保江  \n",
       "322375           1  17783728877        何兵  \n",
       "322913           1  13325128199       袁玉国  \n",
       "323090           1  15349156600       孙启哲  \n",
       "323195           1  18909515060        韩莉  \n",
       "323233           1  18072985702       周子高  \n",
       "323462           1  18958761655       夏孟校  \n",
       "323574           1  15390892146       万其亮  \n",
       "323809           1  13315269839       颜晨旭  \n",
       "324243           1  18013276807       孙宗国  \n",
       "324285           1  17782830285        郑佩  \n",
       "324315           1  18008585666        聂伟  \n",
       "324322           1  18997361277      扎西江才  \n",
       "324521           1  18191591905        李龙  \n",
       "324531           1  17763046830       江培军  \n",
       "324608           1  17778822625       马艳涛  \n",
       "324674           1  18078700907       孔祥贵  \n",
       "324898           1  15343430200       王二牛  \n",
       "\n",
       "[2160 rows x 5 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "overdue = data[data['is_overdue']==1]\n",
    "overdue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:11:24.053487Z",
     "start_time": "2019-11-14T10:11:23.976725Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cert_no_cipher</th>\n",
       "      <th>complete_time</th>\n",
       "      <th>is_overdue</th>\n",
       "      <th>mobile_nbr</th>\n",
       "      <th>user_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6E466B36515853576E66786A4A68693835627565534E74...</td>\n",
       "      <td>2019/4/18 2:24:59</td>\n",
       "      <td>0</td>\n",
       "      <td>15378923256</td>\n",
       "      <td>李瑞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>326C746C693562662B574B466B6D377048394B4D467855...</td>\n",
       "      <td>2019/4/16 3:43:56</td>\n",
       "      <td>0</td>\n",
       "      <td>15378935690</td>\n",
       "      <td>徐淑红</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>326C746C693562662B574B4B61654154623141686B3931...</td>\n",
       "      <td>2019/4/16 7:20:52</td>\n",
       "      <td>0</td>\n",
       "      <td>18095193521</td>\n",
       "      <td>宋鹏明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4D487A57514D35714F517A563547534B4B5130376D5636...</td>\n",
       "      <td>2019/4/15 6:43:27</td>\n",
       "      <td>0</td>\n",
       "      <td>13389520088</td>\n",
       "      <td>方超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2B5841667A34727A364F33786C7752573844667273547A...</td>\n",
       "      <td>2019/4/16 1:50:12</td>\n",
       "      <td>0</td>\n",
       "      <td>17709596636</td>\n",
       "      <td>王继权</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>45545942504A4748754D6E6356756277576F69375A6271...</td>\n",
       "      <td>2019/4/16 9:52:37</td>\n",
       "      <td>0</td>\n",
       "      <td>18161618494</td>\n",
       "      <td>杨忠良</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>676C4B564E2B32676A4C4C6931743048315369345A4D76...</td>\n",
       "      <td>2019/4/17 4:37:42</td>\n",
       "      <td>0</td>\n",
       "      <td>18195306761</td>\n",
       "      <td>马林</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>764B443842704B766A6C4A3865666F314C45786E42736B...</td>\n",
       "      <td>2019/4/16 10:27:53</td>\n",
       "      <td>0</td>\n",
       "      <td>18095453387</td>\n",
       "      <td>朱国斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5369526D63734C445375436E59694877314E3934625A50...</td>\n",
       "      <td>2019/4/16 4:42:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18095276294</td>\n",
       "      <td>吴自斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5369526D63734C44537543327965755839347661455177...</td>\n",
       "      <td>2019/4/19 11:04:43</td>\n",
       "      <td>0</td>\n",
       "      <td>15378930527</td>\n",
       "      <td>伍少波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>764B443842704B766A6C4B614356384C2B6E6F2B5A7A2F...</td>\n",
       "      <td>2019/4/19 3:39:28</td>\n",
       "      <td>0</td>\n",
       "      <td>17795406683</td>\n",
       "      <td>马智林</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>54387776352B634254763157714B677637642F74335259...</td>\n",
       "      <td>2019/4/20 4:32:31</td>\n",
       "      <td>0</td>\n",
       "      <td>17395065415</td>\n",
       "      <td>牛永鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6836315461616431666767417331686D4D384D48482F4D...</td>\n",
       "      <td>2019/4/21 3:26:55</td>\n",
       "      <td>0</td>\n",
       "      <td>17711848033</td>\n",
       "      <td>陈文新</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7645433731724E78494A42612B6A7361685248772B7345...</td>\n",
       "      <td>2019/4/20 9:45:09</td>\n",
       "      <td>0</td>\n",
       "      <td>18995421118</td>\n",
       "      <td>郭振民</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4D487A57514D35714F51796B784E722B2B6F665363307A...</td>\n",
       "      <td>2019/4/20 7:14:23</td>\n",
       "      <td>0</td>\n",
       "      <td>18995055516</td>\n",
       "      <td>钟兴国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>6850444975523668786939683877416B6B494636695357...</td>\n",
       "      <td>2019/4/21 6:26:34</td>\n",
       "      <td>0</td>\n",
       "      <td>18161630046</td>\n",
       "      <td>马学梅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7A4F476D505662487642383462382B2F7151516152394F...</td>\n",
       "      <td>2019/4/18 11:13:32</td>\n",
       "      <td>0</td>\n",
       "      <td>18161601119</td>\n",
       "      <td>马洪军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>6D4C5A584F5562504C726D567A7243354247527A7A7441...</td>\n",
       "      <td>2019/4/20 9:44:26</td>\n",
       "      <td>0</td>\n",
       "      <td>17395098213</td>\n",
       "      <td>崔春</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4E32346A746D454E5330307842743268514873394D4E50...</td>\n",
       "      <td>2019/4/19 9:34:09</td>\n",
       "      <td>0</td>\n",
       "      <td>18909536501</td>\n",
       "      <td>朱王东</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4448525267484D667261534235743930462B2B79504A36...</td>\n",
       "      <td>2019/4/20 6:10:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18109566662</td>\n",
       "      <td>韩磊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2B5841667A34727A364F334C4454726C32574B52367571...</td>\n",
       "      <td>2019/4/20 9:01:33</td>\n",
       "      <td>0</td>\n",
       "      <td>15379545577</td>\n",
       "      <td>郑腾</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>7746673868362F686A68494B6A6A45676B64416A656F4A...</td>\n",
       "      <td>2019/4/21 2:06:09</td>\n",
       "      <td>0</td>\n",
       "      <td>17709532876</td>\n",
       "      <td>王海生</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5A70635A4A576349694159667950316A5332576B304E47...</td>\n",
       "      <td>2019/4/20 3:59:19</td>\n",
       "      <td>0</td>\n",
       "      <td>18169169492</td>\n",
       "      <td>徐艳芬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6E4E58716375423958384A2F4C62626270504478636C6D...</td>\n",
       "      <td>2019/4/19 4:52:36</td>\n",
       "      <td>0</td>\n",
       "      <td>13309541953</td>\n",
       "      <td>海小梅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6E4E5871637542395838497777396C4433345550785533...</td>\n",
       "      <td>2019/4/18 8:53:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18195421805</td>\n",
       "      <td>王翠琴</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>39384B2B517132437A423833397548454B76446D644D48...</td>\n",
       "      <td>2019/4/19 4:52:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18995049773</td>\n",
       "      <td>梁志德</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>594B7A676469787956397A3936734C59716D4272495A6F...</td>\n",
       "      <td>2019/4/20 3:10:24</td>\n",
       "      <td>0</td>\n",
       "      <td>18195462966</td>\n",
       "      <td>张云明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>45545942504A4748754D6D345058364862587547747856...</td>\n",
       "      <td>2019/4/19 9:45:22</td>\n",
       "      <td>0</td>\n",
       "      <td>18195302345</td>\n",
       "      <td>赵瑞清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2B5841667A34727A364F33484273584E7A6368694D7A66...</td>\n",
       "      <td>2019/4/19 6:38:45</td>\n",
       "      <td>0</td>\n",
       "      <td>18195492776</td>\n",
       "      <td>杨极桐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>4448525267484D66726154477565516433513042367275...</td>\n",
       "      <td>2019/4/19 2:48:03</td>\n",
       "      <td>0</td>\n",
       "      <td>15379555644</td>\n",
       "      <td>牛长智</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324906</th>\n",
       "      <td>45556E685656704230316A664634613861345679494250...</td>\n",
       "      <td>2019/1/11 6:45:56</td>\n",
       "      <td>0</td>\n",
       "      <td>18187645670</td>\n",
       "      <td>杨波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324907</th>\n",
       "      <td>4879617436375055536F78544C4F4C637151756E4A2F71...</td>\n",
       "      <td>2019/1/10 5:04:49</td>\n",
       "      <td>0</td>\n",
       "      <td>17732068018</td>\n",
       "      <td>杜永生</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324908</th>\n",
       "      <td>7A736C78735674534A2B554550344973637A744B523246...</td>\n",
       "      <td>2019/1/11 8:19:26</td>\n",
       "      <td>0</td>\n",
       "      <td>13339249515</td>\n",
       "      <td>洪霞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324909</th>\n",
       "      <td>6C50727A772B586D55524F7549335A4578643375524648...</td>\n",
       "      <td>2019/1/10 4:30:59</td>\n",
       "      <td>0</td>\n",
       "      <td>18958510444</td>\n",
       "      <td>周智敏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324910</th>\n",
       "      <td>334B74686D49546167373678326F7A3643637451785545...</td>\n",
       "      <td>2019/1/12 4:39:53</td>\n",
       "      <td>0</td>\n",
       "      <td>13310800070</td>\n",
       "      <td>罗胜神</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324911</th>\n",
       "      <td>366C722F4D62765A42467446784D453866793931725439...</td>\n",
       "      <td>2019/1/11 5:49:30</td>\n",
       "      <td>0</td>\n",
       "      <td>15354138683</td>\n",
       "      <td>饶家松</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324912</th>\n",
       "      <td>4B71565475772B4E42374F69513531594C61426266706A...</td>\n",
       "      <td>2019/1/10 9:27:54</td>\n",
       "      <td>0</td>\n",
       "      <td>13323198537</td>\n",
       "      <td>赵子侠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324913</th>\n",
       "      <td>48556859714D486F45675670627A6A5377516E78324E52...</td>\n",
       "      <td>2019/1/12 3:42:57</td>\n",
       "      <td>0</td>\n",
       "      <td>18058361100</td>\n",
       "      <td>倪立锦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324914</th>\n",
       "      <td>4A7751353650622F33344548412B64557853464665777A...</td>\n",
       "      <td>2019/1/11 2:09:15</td>\n",
       "      <td>0</td>\n",
       "      <td>17723178507</td>\n",
       "      <td>胡波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324915</th>\n",
       "      <td>70424870302F523738494668394D496744494941306A71...</td>\n",
       "      <td>2019/1/10 2:40:49</td>\n",
       "      <td>0</td>\n",
       "      <td>15327697730</td>\n",
       "      <td>陈娟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324916</th>\n",
       "      <td>796C2F2F7A51746D594D2F4A6D694D5578564D4A6E6952...</td>\n",
       "      <td>2019/1/10 8:45:48</td>\n",
       "      <td>0</td>\n",
       "      <td>18076566179</td>\n",
       "      <td>王华英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324917</th>\n",
       "      <td>6C4A44772B5A33724F702B57492F4244354B70376D6E7A...</td>\n",
       "      <td>2019/1/12 2:18:07</td>\n",
       "      <td>0</td>\n",
       "      <td>18925876925</td>\n",
       "      <td>蒋洪卫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324918</th>\n",
       "      <td>5477507071344B776E77476A6D42556D68312B674C5177...</td>\n",
       "      <td>2019/1/10 7:44:59</td>\n",
       "      <td>0</td>\n",
       "      <td>17705161318</td>\n",
       "      <td>盛爱华</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324919</th>\n",
       "      <td>5245774A4D31704A7636336C5336325674777355444137...</td>\n",
       "      <td>2019/1/11 1:00:41</td>\n",
       "      <td>0</td>\n",
       "      <td>18057665898</td>\n",
       "      <td>苏文建</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324920</th>\n",
       "      <td>46465368666B6E6A746634597469484F3468516D526B6B...</td>\n",
       "      <td>2019/1/10 9:34:06</td>\n",
       "      <td>0</td>\n",
       "      <td>18073520747</td>\n",
       "      <td>邓春花</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324921</th>\n",
       "      <td>536269416B6E2B326F6E3677506D414D2F493377664F6B...</td>\n",
       "      <td>2019/1/10 7:41:11</td>\n",
       "      <td>0</td>\n",
       "      <td>18185769817</td>\n",
       "      <td>邓仕军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324922</th>\n",
       "      <td>35345761574D2F565670474D78344F586158477361672F...</td>\n",
       "      <td>2019/1/10 3:31:31</td>\n",
       "      <td>0</td>\n",
       "      <td>18190600591</td>\n",
       "      <td>肖鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324923</th>\n",
       "      <td>7A30385249495848686B4A2B737741537A547648696878...</td>\n",
       "      <td>2019/1/10 4:09:12</td>\n",
       "      <td>0</td>\n",
       "      <td>18100342031</td>\n",
       "      <td>王宇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324924</th>\n",
       "      <td>30466D594766766E764270374E6A66366554476F316A44...</td>\n",
       "      <td>2019/1/10 3:22:31</td>\n",
       "      <td>0</td>\n",
       "      <td>15378635378</td>\n",
       "      <td>陈伯全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324925</th>\n",
       "      <td>555769316E7230394633694A647A634D3334716B583154...</td>\n",
       "      <td>2019/1/10 8:56:16</td>\n",
       "      <td>0</td>\n",
       "      <td>18947102658</td>\n",
       "      <td>魏光复</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324926</th>\n",
       "      <td>4C6F61794544366F4A75413449483552486848546C3137...</td>\n",
       "      <td>2019/1/10 4:59:15</td>\n",
       "      <td>0</td>\n",
       "      <td>18188298382</td>\n",
       "      <td>崔勇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324927</th>\n",
       "      <td>72536246452F56696E4346585862617A4F553645366B56...</td>\n",
       "      <td>2019/1/10 7:36:03</td>\n",
       "      <td>0</td>\n",
       "      <td>13322021056</td>\n",
       "      <td>唐丽敏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324928</th>\n",
       "      <td>766A7568545A507736344971536D5A3036792B52445644...</td>\n",
       "      <td>2019/1/10 5:53:16</td>\n",
       "      <td>0</td>\n",
       "      <td>17704881388</td>\n",
       "      <td>孙涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324929</th>\n",
       "      <td>6C50727A772B586D55524E516357327334546F5A747142...</td>\n",
       "      <td>2019/1/11 8:32:50</td>\n",
       "      <td>0</td>\n",
       "      <td>18968593768</td>\n",
       "      <td>王辉军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324930</th>\n",
       "      <td>30454634376673336E47534541555A6C71345574476F68...</td>\n",
       "      <td>2019/1/10 6:28:55</td>\n",
       "      <td>0</td>\n",
       "      <td>15381022555</td>\n",
       "      <td>戴晓晓</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324931</th>\n",
       "      <td>51437968504C324D304F4C75373561396D2B4836724F64...</td>\n",
       "      <td>2019/1/12 1:10:10</td>\n",
       "      <td>0</td>\n",
       "      <td>15329116529</td>\n",
       "      <td>曹凤燕</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324932</th>\n",
       "      <td>734F565462626F7A524434626965567A45474668356433...</td>\n",
       "      <td>2019/1/10 2:13:26</td>\n",
       "      <td>0</td>\n",
       "      <td>15364000699</td>\n",
       "      <td>周十路</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324933</th>\n",
       "      <td>463175564A78634976756A6D43644B6632714C77417946...</td>\n",
       "      <td>2019/1/11 6:01:19</td>\n",
       "      <td>0</td>\n",
       "      <td>13330590239</td>\n",
       "      <td>黄绍田</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324934</th>\n",
       "      <td>6F79576A71616238552B782B36377A5037656B79524B53...</td>\n",
       "      <td>2019/1/10 5:19:27</td>\n",
       "      <td>0</td>\n",
       "      <td>18094805515</td>\n",
       "      <td>田小兵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324935</th>\n",
       "      <td>645A37523357636F73486C4F4C626D6F56757A714C7854...</td>\n",
       "      <td>2019/1/10 9:09:48</td>\n",
       "      <td>0</td>\n",
       "      <td>18905489778</td>\n",
       "      <td>颜廷俭</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>322776 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           cert_no_cipher       complete_time  \\\n",
       "0       6E466B36515853576E66786A4A68693835627565534E74...   2019/4/18 2:24:59   \n",
       "1       326C746C693562662B574B466B6D377048394B4D467855...   2019/4/16 3:43:56   \n",
       "2       326C746C693562662B574B4B61654154623141686B3931...   2019/4/16 7:20:52   \n",
       "3       4D487A57514D35714F517A563547534B4B5130376D5636...   2019/4/15 6:43:27   \n",
       "4       2B5841667A34727A364F33786C7752573844667273547A...   2019/4/16 1:50:12   \n",
       "5       45545942504A4748754D6E6356756277576F69375A6271...   2019/4/16 9:52:37   \n",
       "6       676C4B564E2B32676A4C4C6931743048315369345A4D76...   2019/4/17 4:37:42   \n",
       "7       764B443842704B766A6C4A3865666F314C45786E42736B...  2019/4/16 10:27:53   \n",
       "8       5369526D63734C445375436E59694877314E3934625A50...   2019/4/16 4:42:28   \n",
       "9       5369526D63734C44537543327965755839347661455177...  2019/4/19 11:04:43   \n",
       "10      764B443842704B766A6C4B614356384C2B6E6F2B5A7A2F...   2019/4/19 3:39:28   \n",
       "11      54387776352B634254763157714B677637642F74335259...   2019/4/20 4:32:31   \n",
       "12      6836315461616431666767417331686D4D384D48482F4D...   2019/4/21 3:26:55   \n",
       "13      7645433731724E78494A42612B6A7361685248772B7345...   2019/4/20 9:45:09   \n",
       "14      4D487A57514D35714F51796B784E722B2B6F665363307A...   2019/4/20 7:14:23   \n",
       "15      6850444975523668786939683877416B6B494636695357...   2019/4/21 6:26:34   \n",
       "16      7A4F476D505662487642383462382B2F7151516152394F...  2019/4/18 11:13:32   \n",
       "17      6D4C5A584F5562504C726D567A7243354247527A7A7441...   2019/4/20 9:44:26   \n",
       "18      4E32346A746D454E5330307842743268514873394D4E50...   2019/4/19 9:34:09   \n",
       "19      4448525267484D667261534235743930462B2B79504A36...   2019/4/20 6:10:39   \n",
       "20      2B5841667A34727A364F334C4454726C32574B52367571...   2019/4/20 9:01:33   \n",
       "21      7746673868362F686A68494B6A6A45676B64416A656F4A...   2019/4/21 2:06:09   \n",
       "22      5A70635A4A576349694159667950316A5332576B304E47...   2019/4/20 3:59:19   \n",
       "23      6E4E58716375423958384A2F4C62626270504478636C6D...   2019/4/19 4:52:36   \n",
       "24      6E4E5871637542395838497777396C4433345550785533...   2019/4/18 8:53:28   \n",
       "25      39384B2B517132437A423833397548454B76446D644D48...   2019/4/19 4:52:39   \n",
       "26      594B7A676469787956397A3936734C59716D4272495A6F...   2019/4/20 3:10:24   \n",
       "27      45545942504A4748754D6D345058364862587547747856...   2019/4/19 9:45:22   \n",
       "28      2B5841667A34727A364F33484273584E7A6368694D7A66...   2019/4/19 6:38:45   \n",
       "29      4448525267484D66726154477565516433513042367275...   2019/4/19 2:48:03   \n",
       "...                                                   ...                 ...   \n",
       "324906  45556E685656704230316A664634613861345679494250...   2019/1/11 6:45:56   \n",
       "324907  4879617436375055536F78544C4F4C637151756E4A2F71...   2019/1/10 5:04:49   \n",
       "324908  7A736C78735674534A2B554550344973637A744B523246...   2019/1/11 8:19:26   \n",
       "324909  6C50727A772B586D55524F7549335A4578643375524648...   2019/1/10 4:30:59   \n",
       "324910  334B74686D49546167373678326F7A3643637451785545...   2019/1/12 4:39:53   \n",
       "324911  366C722F4D62765A42467446784D453866793931725439...   2019/1/11 5:49:30   \n",
       "324912  4B71565475772B4E42374F69513531594C61426266706A...   2019/1/10 9:27:54   \n",
       "324913  48556859714D486F45675670627A6A5377516E78324E52...   2019/1/12 3:42:57   \n",
       "324914  4A7751353650622F33344548412B64557853464665777A...   2019/1/11 2:09:15   \n",
       "324915  70424870302F523738494668394D496744494941306A71...   2019/1/10 2:40:49   \n",
       "324916  796C2F2F7A51746D594D2F4A6D694D5578564D4A6E6952...   2019/1/10 8:45:48   \n",
       "324917  6C4A44772B5A33724F702B57492F4244354B70376D6E7A...   2019/1/12 2:18:07   \n",
       "324918  5477507071344B776E77476A6D42556D68312B674C5177...   2019/1/10 7:44:59   \n",
       "324919  5245774A4D31704A7636336C5336325674777355444137...   2019/1/11 1:00:41   \n",
       "324920  46465368666B6E6A746634597469484F3468516D526B6B...   2019/1/10 9:34:06   \n",
       "324921  536269416B6E2B326F6E3677506D414D2F493377664F6B...   2019/1/10 7:41:11   \n",
       "324922  35345761574D2F565670474D78344F586158477361672F...   2019/1/10 3:31:31   \n",
       "324923  7A30385249495848686B4A2B737741537A547648696878...   2019/1/10 4:09:12   \n",
       "324924  30466D594766766E764270374E6A66366554476F316A44...   2019/1/10 3:22:31   \n",
       "324925  555769316E7230394633694A647A634D3334716B583154...   2019/1/10 8:56:16   \n",
       "324926  4C6F61794544366F4A75413449483552486848546C3137...   2019/1/10 4:59:15   \n",
       "324927  72536246452F56696E4346585862617A4F553645366B56...   2019/1/10 7:36:03   \n",
       "324928  766A7568545A507736344971536D5A3036792B52445644...   2019/1/10 5:53:16   \n",
       "324929  6C50727A772B586D55524E516357327334546F5A747142...   2019/1/11 8:32:50   \n",
       "324930  30454634376673336E47534541555A6C71345574476F68...   2019/1/10 6:28:55   \n",
       "324931  51437968504C324D304F4C75373561396D2B4836724F64...   2019/1/12 1:10:10   \n",
       "324932  734F565462626F7A524434626965567A45474668356433...   2019/1/10 2:13:26   \n",
       "324933  463175564A78634976756A6D43644B6632714C77417946...   2019/1/11 6:01:19   \n",
       "324934  6F79576A71616238552B782B36377A5037656B79524B53...   2019/1/10 5:19:27   \n",
       "324935  645A37523357636F73486C4F4C626D6F56757A714C7854...   2019/1/10 9:09:48   \n",
       "\n",
       "        is_overdue   mobile_nbr user_name  \n",
       "0                0  15378923256        李瑞  \n",
       "1                0  15378935690       徐淑红  \n",
       "2                0  18095193521       宋鹏明  \n",
       "3                0  13389520088        方超  \n",
       "4                0  17709596636       王继权  \n",
       "5                0  18161618494       杨忠良  \n",
       "6                0  18195306761        马林  \n",
       "7                0  18095453387       朱国斌  \n",
       "8                0  18095276294       吴自斌  \n",
       "9                0  15378930527       伍少波  \n",
       "10               0  17795406683       马智林  \n",
       "11               0  17395065415       牛永鑫  \n",
       "12               0  17711848033       陈文新  \n",
       "13               0  18995421118       郭振民  \n",
       "14               0  18995055516       钟兴国  \n",
       "15               0  18161630046       马学梅  \n",
       "16               0  18161601119       马洪军  \n",
       "17               0  17395098213        崔春  \n",
       "18               0  18909536501       朱王东  \n",
       "19               0  18109566662        韩磊  \n",
       "20               0  15379545577        郑腾  \n",
       "21               0  17709532876       王海生  \n",
       "22               0  18169169492       徐艳芬  \n",
       "23               0  13309541953       海小梅  \n",
       "24               0  18195421805       王翠琴  \n",
       "25               0  18995049773       梁志德  \n",
       "26               0  18195462966       张云明  \n",
       "27               0  18195302345       赵瑞清  \n",
       "28               0  18195492776       杨极桐  \n",
       "29               0  15379555644       牛长智  \n",
       "...            ...          ...       ...  \n",
       "324906           0  18187645670        杨波  \n",
       "324907           0  17732068018       杜永生  \n",
       "324908           0  13339249515        洪霞  \n",
       "324909           0  18958510444       周智敏  \n",
       "324910           0  13310800070       罗胜神  \n",
       "324911           0  15354138683       饶家松  \n",
       "324912           0  13323198537       赵子侠  \n",
       "324913           0  18058361100       倪立锦  \n",
       "324914           0  17723178507        胡波  \n",
       "324915           0  15327697730        陈娟  \n",
       "324916           0  18076566179       王华英  \n",
       "324917           0  18925876925       蒋洪卫  \n",
       "324918           0  17705161318       盛爱华  \n",
       "324919           0  18057665898       苏文建  \n",
       "324920           0  18073520747       邓春花  \n",
       "324921           0  18185769817       邓仕军  \n",
       "324922           0  18190600591        肖鑫  \n",
       "324923           0  18100342031        王宇  \n",
       "324924           0  15378635378       陈伯全  \n",
       "324925           0  18947102658       魏光复  \n",
       "324926           0  18188298382        崔勇  \n",
       "324927           0  13322021056       唐丽敏  \n",
       "324928           0  17704881388        孙涛  \n",
       "324929           0  18968593768       王辉军  \n",
       "324930           0  15381022555       戴晓晓  \n",
       "324931           0  15329116529       曹凤燕  \n",
       "324932           0  15364000699       周十路  \n",
       "324933           0  13330590239       黄绍田  \n",
       "324934           0  18094805515       田小兵  \n",
       "324935           0  18905489778       颜廷俭  \n",
       "\n",
       "[322776 rows x 5 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "good = data[data['is_overdue']==0]\n",
    "good"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:14:16.523983Z",
     "start_time": "2019-11-14T10:14:16.453166Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cert_no_cipher</th>\n",
       "      <th>complete_time</th>\n",
       "      <th>is_overdue</th>\n",
       "      <th>mobile_nbr</th>\n",
       "      <th>user_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>142584</th>\n",
       "      <td>36724768494754335170662F47354B434D48527561644C...</td>\n",
       "      <td>2019/2/2 2:43:17</td>\n",
       "      <td>0</td>\n",
       "      <td>13378020600</td>\n",
       "      <td>赵智清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319849</th>\n",
       "      <td>4A554F7A5758642F532F372B6E735A5038746A67303166...</td>\n",
       "      <td>2019/1/26 5:09:11</td>\n",
       "      <td>0</td>\n",
       "      <td>18907523452</td>\n",
       "      <td>占兴武</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27455</th>\n",
       "      <td>752B437272496C5442317378693049794743696E73332F...</td>\n",
       "      <td>2019/3/1 12:19:04</td>\n",
       "      <td>0</td>\n",
       "      <td>18060278836</td>\n",
       "      <td>李洪发</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114996</th>\n",
       "      <td>63514C305A4D57387A694F6B72366936666D38502F766B...</td>\n",
       "      <td>2019/2/11 4:20:18</td>\n",
       "      <td>0</td>\n",
       "      <td>17770301204</td>\n",
       "      <td>辜庭钟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143047</th>\n",
       "      <td>6F4E62427547547948704657512B43687976494371612F...</td>\n",
       "      <td>2019/2/16 5:07:04</td>\n",
       "      <td>0</td>\n",
       "      <td>18988393604</td>\n",
       "      <td>杨丽萍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321956</th>\n",
       "      <td>6F6557306F613758676A67314F754E5855344D594E6B2B...</td>\n",
       "      <td>2019/1/9 9:14:34</td>\n",
       "      <td>0</td>\n",
       "      <td>18909358393</td>\n",
       "      <td>杨天斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125222</th>\n",
       "      <td>7347496C4847524B546F4A56396D79766743334F624635...</td>\n",
       "      <td>2019/2/13 3:57:37</td>\n",
       "      <td>0</td>\n",
       "      <td>17709791659</td>\n",
       "      <td>裴正露</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233850</th>\n",
       "      <td>37396D674D73334D413764652B4B484249656735326365...</td>\n",
       "      <td>2019/1/24 2:41:09</td>\n",
       "      <td>0</td>\n",
       "      <td>18175790586</td>\n",
       "      <td>何少军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279837</th>\n",
       "      <td>4F50732B38664E5A634F76764B4A716D78316935326C62...</td>\n",
       "      <td>2019/1/15 8:43:48</td>\n",
       "      <td>0</td>\n",
       "      <td>18067713005</td>\n",
       "      <td>方万云</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24014</th>\n",
       "      <td>5454704E656747624930675769673343304F5A4E2F4B70...</td>\n",
       "      <td>2019/3/7 6:38:41</td>\n",
       "      <td>0</td>\n",
       "      <td>13302715598</td>\n",
       "      <td>洪泽荣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312978</th>\n",
       "      <td>694F57615136566E5A304E51586248314F4A53714B6B37...</td>\n",
       "      <td>2019/1/12 9:22:31</td>\n",
       "      <td>0</td>\n",
       "      <td>18137773659</td>\n",
       "      <td>成本芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321011</th>\n",
       "      <td>32394C2F595A38702F39556445612F2B35502B55495855...</td>\n",
       "      <td>2019/1/27 1:14:45</td>\n",
       "      <td>0</td>\n",
       "      <td>18934393557</td>\n",
       "      <td>崔家荣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208062</th>\n",
       "      <td>3775707A2B7A734A6F66503956567A6A41563651356A53...</td>\n",
       "      <td>2019/1/4 6:45:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18992555091</td>\n",
       "      <td>甘琪全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11259</th>\n",
       "      <td>6B476831597A5077745A5730324D73667066564E374F50...</td>\n",
       "      <td>2019/3/14 8:44:20</td>\n",
       "      <td>0</td>\n",
       "      <td>18003544444</td>\n",
       "      <td>石云峰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218920</th>\n",
       "      <td>584475544D61547674496F314367476545744657556551...</td>\n",
       "      <td>2019/1/21 7:23:35</td>\n",
       "      <td>0</td>\n",
       "      <td>18097472389</td>\n",
       "      <td>安明善</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269579</th>\n",
       "      <td>5A57774730307053764E6D527762434C592B3363454135...</td>\n",
       "      <td>2019/1/2 5:47:29</td>\n",
       "      <td>0</td>\n",
       "      <td>18997648672</td>\n",
       "      <td>甄芸</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>7A5372437576716D364672552F5871395273414D30792B...</td>\n",
       "      <td>2019/4/13 6:19:20</td>\n",
       "      <td>0</td>\n",
       "      <td>18195174561</td>\n",
       "      <td>王凯</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305218</th>\n",
       "      <td>62737A644772564F704C7669567354646175596C655859...</td>\n",
       "      <td>2019/1/19 8:26:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18135935950</td>\n",
       "      <td>路祥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20494</th>\n",
       "      <td>584B474D3461636B546833783731536575537A46505643...</td>\n",
       "      <td>2019/3/2 4:41:46</td>\n",
       "      <td>0</td>\n",
       "      <td>15336129222</td>\n",
       "      <td>李春芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279623</th>\n",
       "      <td>6D41446250427241633839336F6B4135672F756C4D6C57...</td>\n",
       "      <td>2019/1/19 8:14:21</td>\n",
       "      <td>0</td>\n",
       "      <td>17720365380</td>\n",
       "      <td>郝明章</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182075</th>\n",
       "      <td>514A465638514B73634B4C67527457395A325834685853...</td>\n",
       "      <td>2019/1/30 5:38:49</td>\n",
       "      <td>0</td>\n",
       "      <td>18932676097</td>\n",
       "      <td>刘建龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115732</th>\n",
       "      <td>383461686E636C79656676323638305252556673627876...</td>\n",
       "      <td>2019/2/28 6:32:45</td>\n",
       "      <td>0</td>\n",
       "      <td>17331617007</td>\n",
       "      <td>史春龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159688</th>\n",
       "      <td>46656D443131505647614275554467454377314245487A...</td>\n",
       "      <td>2019/2/9 6:21:59</td>\n",
       "      <td>0</td>\n",
       "      <td>18990031920</td>\n",
       "      <td>孙建</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281141</th>\n",
       "      <td>5774394A5A394E4B3046424E47322F7272683942457950...</td>\n",
       "      <td>2019/1/11 5:42:21</td>\n",
       "      <td>0</td>\n",
       "      <td>13399996669</td>\n",
       "      <td>张君新</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108458</th>\n",
       "      <td>6E726E3779795855706F51513169753753544774664E65...</td>\n",
       "      <td>2019/7/15 3:19:44</td>\n",
       "      <td>0</td>\n",
       "      <td>18128909150</td>\n",
       "      <td>周金清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285724</th>\n",
       "      <td>6D5050504831325073594A657A424443494A374F634138...</td>\n",
       "      <td>2019/1/29 4:10:04</td>\n",
       "      <td>0</td>\n",
       "      <td>13317337133</td>\n",
       "      <td>张斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33415</th>\n",
       "      <td>614F37372B452B566E62754B69474149766C4578305738...</td>\n",
       "      <td>2019/3/12 2:49:34</td>\n",
       "      <td>0</td>\n",
       "      <td>17362500590</td>\n",
       "      <td>王定全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129495</th>\n",
       "      <td>634A2B615165656D536F4A507878685955583353335337...</td>\n",
       "      <td>2019/2/27 5:05:14</td>\n",
       "      <td>0</td>\n",
       "      <td>18976326545</td>\n",
       "      <td>庹兴胜</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93532</th>\n",
       "      <td>64657A694E397877554A493664796130466F58555A5953...</td>\n",
       "      <td>2019/7/20 10:22:55</td>\n",
       "      <td>0</td>\n",
       "      <td>18103301169</td>\n",
       "      <td>王英华</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313638</th>\n",
       "      <td>30416D357973676E354373627541436435796D706B3758...</td>\n",
       "      <td>2019/1/11 4:05:43</td>\n",
       "      <td>0</td>\n",
       "      <td>18969055678</td>\n",
       "      <td>阚建利</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124783</th>\n",
       "      <td>4D4346766350354444337431327376727773766E616861...</td>\n",
       "      <td>2019/2/16 6:26:41</td>\n",
       "      <td>0</td>\n",
       "      <td>17731111105</td>\n",
       "      <td>贾志博</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85128</th>\n",
       "      <td>4C455542735639337332754270596E4C62595474303859...</td>\n",
       "      <td>2019/7/18 5:11:58</td>\n",
       "      <td>0</td>\n",
       "      <td>18941363699</td>\n",
       "      <td>张淑姝</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258403</th>\n",
       "      <td>4C4374734A7376567734412B56564F436B6B324A385777...</td>\n",
       "      <td>2019/1/2 6:32:05</td>\n",
       "      <td>0</td>\n",
       "      <td>18174621616</td>\n",
       "      <td>唐云生</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125421</th>\n",
       "      <td>32305779672B5357576B644235484B704D4B614D56705A...</td>\n",
       "      <td>2019/2/14 5:12:48</td>\n",
       "      <td>0</td>\n",
       "      <td>17738198310</td>\n",
       "      <td>易遵洪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177099</th>\n",
       "      <td>757073386C5965502F59587534364666584766446A5264...</td>\n",
       "      <td>2019/2/12 7:53:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18061139001</td>\n",
       "      <td>邹欢欢</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29552</th>\n",
       "      <td>4752313756736B63317979366B6C66474C514662375247...</td>\n",
       "      <td>2019/3/1 7:51:34</td>\n",
       "      <td>0</td>\n",
       "      <td>18098005846</td>\n",
       "      <td>牛效彦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171583</th>\n",
       "      <td>77343739706E71417955787A78526C3276666E70316B75...</td>\n",
       "      <td>2019/2/3 2:36:40</td>\n",
       "      <td>0</td>\n",
       "      <td>18045074930</td>\n",
       "      <td>陈爱军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306267</th>\n",
       "      <td>4475767A596E794A31514341543565364E30676C6A5962...</td>\n",
       "      <td>2019/1/25 3:46:11</td>\n",
       "      <td>0</td>\n",
       "      <td>18132219692</td>\n",
       "      <td>孙金明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72319</th>\n",
       "      <td>6A692B4D353046734176546E416D627336532F726A6C58...</td>\n",
       "      <td>2019/7/21 8:44:48</td>\n",
       "      <td>0</td>\n",
       "      <td>17781337290</td>\n",
       "      <td>黄河</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224001</th>\n",
       "      <td>563443784D47624D4B45586741535161366A64437A496C...</td>\n",
       "      <td>2019/1/21 8:31:18</td>\n",
       "      <td>0</td>\n",
       "      <td>18970412718</td>\n",
       "      <td>胡声略</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143893</th>\n",
       "      <td>79735478496D7963672F3736644F467570796C416F4C64...</td>\n",
       "      <td>2019/2/18 7:10:38</td>\n",
       "      <td>0</td>\n",
       "      <td>17313239636</td>\n",
       "      <td>张鹏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211261</th>\n",
       "      <td>4378325451555544312F6D447546657673496675346930...</td>\n",
       "      <td>2019/1/17 6:10:17</td>\n",
       "      <td>0</td>\n",
       "      <td>13331310319</td>\n",
       "      <td>忻天琪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73403</th>\n",
       "      <td>63324C7446565551366633516A794F522B573345425952...</td>\n",
       "      <td>2019/7/11 5:27:33</td>\n",
       "      <td>0</td>\n",
       "      <td>18023606126</td>\n",
       "      <td>王威</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203855</th>\n",
       "      <td>7A6D7A6E5556414F626E3239336576745374715A343244...</td>\n",
       "      <td>2019/1/1 4:53:24</td>\n",
       "      <td>0</td>\n",
       "      <td>15397017263</td>\n",
       "      <td>张军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77322</th>\n",
       "      <td>5A51726473556644414265365848634B57363445485157...</td>\n",
       "      <td>2019/7/11 3:10:01</td>\n",
       "      <td>0</td>\n",
       "      <td>18008639332</td>\n",
       "      <td>冷裕都</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167206</th>\n",
       "      <td>646A767375764F4B6A63554E706D6857436E4F6933786C...</td>\n",
       "      <td>2019/2/24 6:46:53</td>\n",
       "      <td>0</td>\n",
       "      <td>18195870231</td>\n",
       "      <td>张国辉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161714</th>\n",
       "      <td>7348675A68614D6D673031386E2B75627963756E443377...</td>\n",
       "      <td>2019/2/22 3:20:00</td>\n",
       "      <td>0</td>\n",
       "      <td>18004769111</td>\n",
       "      <td>陈玉贵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109194</th>\n",
       "      <td>6E5371564D48574E4D7A3952466135627A30556434374B...</td>\n",
       "      <td>2019/7/8 10:24:24</td>\n",
       "      <td>0</td>\n",
       "      <td>13376206627</td>\n",
       "      <td>魏圆圆</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92882</th>\n",
       "      <td>35537333616B4C386D6E396C722B2B4F466974394D592B...</td>\n",
       "      <td>2019/7/15 4:09:40</td>\n",
       "      <td>0</td>\n",
       "      <td>18096251916</td>\n",
       "      <td>刘祥刚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148289</th>\n",
       "      <td>784758796555374C6C576B41562B33707A79716D516359...</td>\n",
       "      <td>2019/2/2 4:16:59</td>\n",
       "      <td>0</td>\n",
       "      <td>18985931579</td>\n",
       "      <td>许振坤</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279105</th>\n",
       "      <td>68644C57716B5359524E796C332F596D6D575568723667...</td>\n",
       "      <td>2019/1/26 5:07:53</td>\n",
       "      <td>0</td>\n",
       "      <td>13307267988</td>\n",
       "      <td>薛劲松</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237506</th>\n",
       "      <td>475565712F4B7947394E6A706C48687273774C37624469...</td>\n",
       "      <td>2019/1/28 3:38:59</td>\n",
       "      <td>0</td>\n",
       "      <td>15364062434</td>\n",
       "      <td>王顺利</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122693</th>\n",
       "      <td>3956545544746773753337514C385A68733530764A7232...</td>\n",
       "      <td>2019/2/21 9:11:20</td>\n",
       "      <td>0</td>\n",
       "      <td>15327198861</td>\n",
       "      <td>张鹏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6899</th>\n",
       "      <td>7942616C54795748794B76576D7A325A515A454E6A4E69...</td>\n",
       "      <td>2019/5/24 4:33:19</td>\n",
       "      <td>0</td>\n",
       "      <td>18905380524</td>\n",
       "      <td>张伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30722</th>\n",
       "      <td>7361394A39482F5954566C644858447531644D77706C54...</td>\n",
       "      <td>2019/3/14 10:21:51</td>\n",
       "      <td>0</td>\n",
       "      <td>18020903776</td>\n",
       "      <td>李志忠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239872</th>\n",
       "      <td>7347496C4847524B546F49762F454847596F6D51504557...</td>\n",
       "      <td>2019/1/12 6:07:38</td>\n",
       "      <td>0</td>\n",
       "      <td>18109792311</td>\n",
       "      <td>安国知</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265742</th>\n",
       "      <td>692B35507133744D3473514964494339624367585A6E45...</td>\n",
       "      <td>2019/1/1 8:38:39</td>\n",
       "      <td>0</td>\n",
       "      <td>17745643245</td>\n",
       "      <td>张博文</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217333</th>\n",
       "      <td>3775377662454947494365306A4E747253504379447470...</td>\n",
       "      <td>2019/1/28 10:04:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18170054003</td>\n",
       "      <td>揭云标</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142050</th>\n",
       "      <td>6A2F64633345644A63437A452B2F726C69386B64387A52...</td>\n",
       "      <td>2019/2/17 9:52:30</td>\n",
       "      <td>0</td>\n",
       "      <td>13313113912</td>\n",
       "      <td>石亚然</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74792</th>\n",
       "      <td>35537333616B4C386D6E39707630324758394A39685550...</td>\n",
       "      <td>2019/7/26 2:51:56</td>\n",
       "      <td>0</td>\n",
       "      <td>18924731888</td>\n",
       "      <td>刘用盛</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17840 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           cert_no_cipher       complete_time  \\\n",
       "142584  36724768494754335170662F47354B434D48527561644C...    2019/2/2 2:43:17   \n",
       "319849  4A554F7A5758642F532F372B6E735A5038746A67303166...   2019/1/26 5:09:11   \n",
       "27455   752B437272496C5442317378693049794743696E73332F...   2019/3/1 12:19:04   \n",
       "114996  63514C305A4D57387A694F6B72366936666D38502F766B...   2019/2/11 4:20:18   \n",
       "143047  6F4E62427547547948704657512B43687976494371612F...   2019/2/16 5:07:04   \n",
       "321956  6F6557306F613758676A67314F754E5855344D594E6B2B...    2019/1/9 9:14:34   \n",
       "125222  7347496C4847524B546F4A56396D79766743334F624635...   2019/2/13 3:57:37   \n",
       "233850  37396D674D73334D413764652B4B484249656735326365...   2019/1/24 2:41:09   \n",
       "279837  4F50732B38664E5A634F76764B4A716D78316935326C62...   2019/1/15 8:43:48   \n",
       "24014   5454704E656747624930675769673343304F5A4E2F4B70...    2019/3/7 6:38:41   \n",
       "312978  694F57615136566E5A304E51586248314F4A53714B6B37...   2019/1/12 9:22:31   \n",
       "321011  32394C2F595A38702F39556445612F2B35502B55495855...   2019/1/27 1:14:45   \n",
       "208062  3775707A2B7A734A6F66503956567A6A41563651356A53...    2019/1/4 6:45:39   \n",
       "11259   6B476831597A5077745A5730324D73667066564E374F50...   2019/3/14 8:44:20   \n",
       "218920  584475544D61547674496F314367476545744657556551...   2019/1/21 7:23:35   \n",
       "269579  5A57774730307053764E6D527762434C592B3363454135...    2019/1/2 5:47:29   \n",
       "265     7A5372437576716D364672552F5871395273414D30792B...   2019/4/13 6:19:20   \n",
       "305218  62737A644772564F704C7669567354646175596C655859...   2019/1/19 8:26:28   \n",
       "20494   584B474D3461636B546833783731536575537A46505643...    2019/3/2 4:41:46   \n",
       "279623  6D41446250427241633839336F6B4135672F756C4D6C57...   2019/1/19 8:14:21   \n",
       "182075  514A465638514B73634B4C67527457395A325834685853...   2019/1/30 5:38:49   \n",
       "115732  383461686E636C79656676323638305252556673627876...   2019/2/28 6:32:45   \n",
       "159688  46656D443131505647614275554467454377314245487A...    2019/2/9 6:21:59   \n",
       "281141  5774394A5A394E4B3046424E47322F7272683942457950...   2019/1/11 5:42:21   \n",
       "108458  6E726E3779795855706F51513169753753544774664E65...   2019/7/15 3:19:44   \n",
       "285724  6D5050504831325073594A657A424443494A374F634138...   2019/1/29 4:10:04   \n",
       "33415   614F37372B452B566E62754B69474149766C4578305738...   2019/3/12 2:49:34   \n",
       "129495  634A2B615165656D536F4A507878685955583353335337...   2019/2/27 5:05:14   \n",
       "93532   64657A694E397877554A493664796130466F58555A5953...  2019/7/20 10:22:55   \n",
       "313638  30416D357973676E354373627541436435796D706B3758...   2019/1/11 4:05:43   \n",
       "...                                                   ...                 ...   \n",
       "124783  4D4346766350354444337431327376727773766E616861...   2019/2/16 6:26:41   \n",
       "85128   4C455542735639337332754270596E4C62595474303859...   2019/7/18 5:11:58   \n",
       "258403  4C4374734A7376567734412B56564F436B6B324A385777...    2019/1/2 6:32:05   \n",
       "125421  32305779672B5357576B644235484B704D4B614D56705A...   2019/2/14 5:12:48   \n",
       "177099  757073386C5965502F59587534364666584766446A5264...   2019/2/12 7:53:28   \n",
       "29552   4752313756736B63317979366B6C66474C514662375247...    2019/3/1 7:51:34   \n",
       "171583  77343739706E71417955787A78526C3276666E70316B75...    2019/2/3 2:36:40   \n",
       "306267  4475767A596E794A31514341543565364E30676C6A5962...   2019/1/25 3:46:11   \n",
       "72319   6A692B4D353046734176546E416D627336532F726A6C58...   2019/7/21 8:44:48   \n",
       "224001  563443784D47624D4B45586741535161366A64437A496C...   2019/1/21 8:31:18   \n",
       "143893  79735478496D7963672F3736644F467570796C416F4C64...   2019/2/18 7:10:38   \n",
       "211261  4378325451555544312F6D447546657673496675346930...   2019/1/17 6:10:17   \n",
       "73403   63324C7446565551366633516A794F522B573345425952...   2019/7/11 5:27:33   \n",
       "203855  7A6D7A6E5556414F626E3239336576745374715A343244...    2019/1/1 4:53:24   \n",
       "77322   5A51726473556644414265365848634B57363445485157...   2019/7/11 3:10:01   \n",
       "167206  646A767375764F4B6A63554E706D6857436E4F6933786C...   2019/2/24 6:46:53   \n",
       "161714  7348675A68614D6D673031386E2B75627963756E443377...   2019/2/22 3:20:00   \n",
       "109194  6E5371564D48574E4D7A3952466135627A30556434374B...   2019/7/8 10:24:24   \n",
       "92882   35537333616B4C386D6E396C722B2B4F466974394D592B...   2019/7/15 4:09:40   \n",
       "148289  784758796555374C6C576B41562B33707A79716D516359...    2019/2/2 4:16:59   \n",
       "279105  68644C57716B5359524E796C332F596D6D575568723667...   2019/1/26 5:07:53   \n",
       "237506  475565712F4B7947394E6A706C48687273774C37624469...   2019/1/28 3:38:59   \n",
       "122693  3956545544746773753337514C385A68733530764A7232...   2019/2/21 9:11:20   \n",
       "6899    7942616C54795748794B76576D7A325A515A454E6A4E69...   2019/5/24 4:33:19   \n",
       "30722   7361394A39482F5954566C644858447531644D77706C54...  2019/3/14 10:21:51   \n",
       "239872  7347496C4847524B546F49762F454847596F6D51504557...   2019/1/12 6:07:38   \n",
       "265742  692B35507133744D3473514964494339624367585A6E45...    2019/1/1 8:38:39   \n",
       "217333  3775377662454947494365306A4E747253504379447470...  2019/1/28 10:04:39   \n",
       "142050  6A2F64633345644A63437A452B2F726C69386B64387A52...   2019/2/17 9:52:30   \n",
       "74792   35537333616B4C386D6E39707630324758394A39685550...   2019/7/26 2:51:56   \n",
       "\n",
       "        is_overdue   mobile_nbr user_name  \n",
       "142584           0  13378020600       赵智清  \n",
       "319849           0  18907523452       占兴武  \n",
       "27455            0  18060278836       李洪发  \n",
       "114996           0  17770301204       辜庭钟  \n",
       "143047           0  18988393604       杨丽萍  \n",
       "321956           0  18909358393       杨天斌  \n",
       "125222           0  17709791659       裴正露  \n",
       "233850           0  18175790586       何少军  \n",
       "279837           0  18067713005       方万云  \n",
       "24014            0  13302715598       洪泽荣  \n",
       "312978           0  18137773659       成本芳  \n",
       "321011           0  18934393557       崔家荣  \n",
       "208062           0  18992555091       甘琪全  \n",
       "11259            0  18003544444       石云峰  \n",
       "218920           0  18097472389       安明善  \n",
       "269579           0  18997648672        甄芸  \n",
       "265              0  18195174561        王凯  \n",
       "305218           0  18135935950        路祥  \n",
       "20494            0  15336129222       李春芳  \n",
       "279623           0  17720365380       郝明章  \n",
       "182075           0  18932676097       刘建龙  \n",
       "115732           0  17331617007       史春龙  \n",
       "159688           0  18990031920        孙建  \n",
       "281141           0  13399996669       张君新  \n",
       "108458           0  18128909150       周金清  \n",
       "285724           0  13317337133        张斌  \n",
       "33415            0  17362500590       王定全  \n",
       "129495           0  18976326545       庹兴胜  \n",
       "93532            0  18103301169       王英华  \n",
       "313638           0  18969055678       阚建利  \n",
       "...            ...          ...       ...  \n",
       "124783           0  17731111105       贾志博  \n",
       "85128            0  18941363699       张淑姝  \n",
       "258403           0  18174621616       唐云生  \n",
       "125421           0  17738198310       易遵洪  \n",
       "177099           0  18061139001       邹欢欢  \n",
       "29552            0  18098005846       牛效彦  \n",
       "171583           0  18045074930       陈爱军  \n",
       "306267           0  18132219692       孙金明  \n",
       "72319            0  17781337290        黄河  \n",
       "224001           0  18970412718       胡声略  \n",
       "143893           0  17313239636        张鹏  \n",
       "211261           0  13331310319       忻天琪  \n",
       "73403            0  18023606126        王威  \n",
       "203855           0  15397017263        张军  \n",
       "77322            0  18008639332       冷裕都  \n",
       "167206           0  18195870231       张国辉  \n",
       "161714           0  18004769111       陈玉贵  \n",
       "109194           0  13376206627       魏圆圆  \n",
       "92882            0  18096251916       刘祥刚  \n",
       "148289           0  18985931579       许振坤  \n",
       "279105           0  13307267988       薛劲松  \n",
       "237506           0  15364062434       王顺利  \n",
       "122693           0  15327198861        张鹏  \n",
       "6899             0  18905380524        张伟  \n",
       "30722            0  18020903776       李志忠  \n",
       "239872           0  18109792311       安国知  \n",
       "265742           0  17745643245       张博文  \n",
       "217333           0  18170054003       揭云标  \n",
       "142050           0  13313113912       石亚然  \n",
       "74792            0  18924731888       刘用盛  \n",
       "\n",
       "[17840 rows x 5 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "last = good.sample(n=17840, replace=False, axis=0)\n",
    "last"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:16:35.459198Z",
     "start_time": "2019-11-14T10:16:35.399360Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cert_no_cipher</th>\n",
       "      <th>complete_time</th>\n",
       "      <th>is_overdue</th>\n",
       "      <th>mobile_nbr</th>\n",
       "      <th>user_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>36724768494754335170662F47354B434D48527561644C...</td>\n",
       "      <td>2019/2/2 2:43:17</td>\n",
       "      <td>0</td>\n",
       "      <td>13378020600</td>\n",
       "      <td>赵智清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4A554F7A5758642F532F372B6E735A5038746A67303166...</td>\n",
       "      <td>2019/1/26 5:09:11</td>\n",
       "      <td>0</td>\n",
       "      <td>18907523452</td>\n",
       "      <td>占兴武</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>752B437272496C5442317378693049794743696E73332F...</td>\n",
       "      <td>2019/3/1 12:19:04</td>\n",
       "      <td>0</td>\n",
       "      <td>18060278836</td>\n",
       "      <td>李洪发</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>63514C305A4D57387A694F6B72366936666D38502F766B...</td>\n",
       "      <td>2019/2/11 4:20:18</td>\n",
       "      <td>0</td>\n",
       "      <td>17770301204</td>\n",
       "      <td>辜庭钟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6F4E62427547547948704657512B43687976494371612F...</td>\n",
       "      <td>2019/2/16 5:07:04</td>\n",
       "      <td>0</td>\n",
       "      <td>18988393604</td>\n",
       "      <td>杨丽萍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6F6557306F613758676A67314F754E5855344D594E6B2B...</td>\n",
       "      <td>2019/1/9 9:14:34</td>\n",
       "      <td>0</td>\n",
       "      <td>18909358393</td>\n",
       "      <td>杨天斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7347496C4847524B546F4A56396D79766743334F624635...</td>\n",
       "      <td>2019/2/13 3:57:37</td>\n",
       "      <td>0</td>\n",
       "      <td>17709791659</td>\n",
       "      <td>裴正露</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>37396D674D73334D413764652B4B484249656735326365...</td>\n",
       "      <td>2019/1/24 2:41:09</td>\n",
       "      <td>0</td>\n",
       "      <td>18175790586</td>\n",
       "      <td>何少军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4F50732B38664E5A634F76764B4A716D78316935326C62...</td>\n",
       "      <td>2019/1/15 8:43:48</td>\n",
       "      <td>0</td>\n",
       "      <td>18067713005</td>\n",
       "      <td>方万云</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5454704E656747624930675769673343304F5A4E2F4B70...</td>\n",
       "      <td>2019/3/7 6:38:41</td>\n",
       "      <td>0</td>\n",
       "      <td>13302715598</td>\n",
       "      <td>洪泽荣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>694F57615136566E5A304E51586248314F4A53714B6B37...</td>\n",
       "      <td>2019/1/12 9:22:31</td>\n",
       "      <td>0</td>\n",
       "      <td>18137773659</td>\n",
       "      <td>成本芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>32394C2F595A38702F39556445612F2B35502B55495855...</td>\n",
       "      <td>2019/1/27 1:14:45</td>\n",
       "      <td>0</td>\n",
       "      <td>18934393557</td>\n",
       "      <td>崔家荣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3775707A2B7A734A6F66503956567A6A41563651356A53...</td>\n",
       "      <td>2019/1/4 6:45:39</td>\n",
       "      <td>0</td>\n",
       "      <td>18992555091</td>\n",
       "      <td>甘琪全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6B476831597A5077745A5730324D73667066564E374F50...</td>\n",
       "      <td>2019/3/14 8:44:20</td>\n",
       "      <td>0</td>\n",
       "      <td>18003544444</td>\n",
       "      <td>石云峰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>584475544D61547674496F314367476545744657556551...</td>\n",
       "      <td>2019/1/21 7:23:35</td>\n",
       "      <td>0</td>\n",
       "      <td>18097472389</td>\n",
       "      <td>安明善</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5A57774730307053764E6D527762434C592B3363454135...</td>\n",
       "      <td>2019/1/2 5:47:29</td>\n",
       "      <td>0</td>\n",
       "      <td>18997648672</td>\n",
       "      <td>甄芸</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7A5372437576716D364672552F5871395273414D30792B...</td>\n",
       "      <td>2019/4/13 6:19:20</td>\n",
       "      <td>0</td>\n",
       "      <td>18195174561</td>\n",
       "      <td>王凯</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>62737A644772564F704C7669567354646175596C655859...</td>\n",
       "      <td>2019/1/19 8:26:28</td>\n",
       "      <td>0</td>\n",
       "      <td>18135935950</td>\n",
       "      <td>路祥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>584B474D3461636B546833783731536575537A46505643...</td>\n",
       "      <td>2019/3/2 4:41:46</td>\n",
       "      <td>0</td>\n",
       "      <td>15336129222</td>\n",
       "      <td>李春芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>6D41446250427241633839336F6B4135672F756C4D6C57...</td>\n",
       "      <td>2019/1/19 8:14:21</td>\n",
       "      <td>0</td>\n",
       "      <td>17720365380</td>\n",
       "      <td>郝明章</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>514A465638514B73634B4C67527457395A325834685853...</td>\n",
       "      <td>2019/1/30 5:38:49</td>\n",
       "      <td>0</td>\n",
       "      <td>18932676097</td>\n",
       "      <td>刘建龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>383461686E636C79656676323638305252556673627876...</td>\n",
       "      <td>2019/2/28 6:32:45</td>\n",
       "      <td>0</td>\n",
       "      <td>17331617007</td>\n",
       "      <td>史春龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>46656D443131505647614275554467454377314245487A...</td>\n",
       "      <td>2019/2/9 6:21:59</td>\n",
       "      <td>0</td>\n",
       "      <td>18990031920</td>\n",
       "      <td>孙建</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5774394A5A394E4B3046424E47322F7272683942457950...</td>\n",
       "      <td>2019/1/11 5:42:21</td>\n",
       "      <td>0</td>\n",
       "      <td>13399996669</td>\n",
       "      <td>张君新</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6E726E3779795855706F51513169753753544774664E65...</td>\n",
       "      <td>2019/7/15 3:19:44</td>\n",
       "      <td>0</td>\n",
       "      <td>18128909150</td>\n",
       "      <td>周金清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6D5050504831325073594A657A424443494A374F634138...</td>\n",
       "      <td>2019/1/29 4:10:04</td>\n",
       "      <td>0</td>\n",
       "      <td>13317337133</td>\n",
       "      <td>张斌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>614F37372B452B566E62754B69474149766C4578305738...</td>\n",
       "      <td>2019/3/12 2:49:34</td>\n",
       "      <td>0</td>\n",
       "      <td>17362500590</td>\n",
       "      <td>王定全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>634A2B615165656D536F4A507878685955583353335337...</td>\n",
       "      <td>2019/2/27 5:05:14</td>\n",
       "      <td>0</td>\n",
       "      <td>18976326545</td>\n",
       "      <td>庹兴胜</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>64657A694E397877554A493664796130466F58555A5953...</td>\n",
       "      <td>2019/7/20 10:22:55</td>\n",
       "      <td>0</td>\n",
       "      <td>18103301169</td>\n",
       "      <td>王英华</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30416D357973676E354373627541436435796D706B3758...</td>\n",
       "      <td>2019/1/11 4:05:43</td>\n",
       "      <td>0</td>\n",
       "      <td>18969055678</td>\n",
       "      <td>阚建利</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19970</th>\n",
       "      <td>63532F2B4A4A7531392B46467676494A4677474D777162...</td>\n",
       "      <td>2019/1/27 4:31:04</td>\n",
       "      <td>1</td>\n",
       "      <td>13320642130</td>\n",
       "      <td>吴军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19971</th>\n",
       "      <td>734C6453723264563574502F42794D764B736F4B656973...</td>\n",
       "      <td>2019/1/27 5:19:14</td>\n",
       "      <td>1</td>\n",
       "      <td>18005707088</td>\n",
       "      <td>王素军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19972</th>\n",
       "      <td>315971446939746C6D4C3448563348734731335171676E...</td>\n",
       "      <td>2019/1/27 2:59:40</td>\n",
       "      <td>1</td>\n",
       "      <td>17764908905</td>\n",
       "      <td>黄明英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19973</th>\n",
       "      <td>48416656744C624753697337566F31514338426853736B...</td>\n",
       "      <td>2019/1/26 6:21:19</td>\n",
       "      <td>1</td>\n",
       "      <td>17763941351</td>\n",
       "      <td>胡亚贵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19974</th>\n",
       "      <td>62737A644772564F704C765570573078756C4450386561...</td>\n",
       "      <td>2019/1/26 6:47:42</td>\n",
       "      <td>1</td>\n",
       "      <td>13303483112</td>\n",
       "      <td>王兴坤</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19975</th>\n",
       "      <td>6668316677655959736B2B69503449426C427971705031...</td>\n",
       "      <td>2019/1/13 7:22:44</td>\n",
       "      <td>1</td>\n",
       "      <td>18968553952</td>\n",
       "      <td>庞建民</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19976</th>\n",
       "      <td>566B7274526334456E4E45764E2F4B303941306E354474...</td>\n",
       "      <td>2019/1/13 2:09:56</td>\n",
       "      <td>1</td>\n",
       "      <td>17705987397</td>\n",
       "      <td>邓茂官</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19977</th>\n",
       "      <td>387A4D647135543944736431473277326C396C785A6176...</td>\n",
       "      <td>2019/1/15 8:09:45</td>\n",
       "      <td>1</td>\n",
       "      <td>13305765221</td>\n",
       "      <td>金良江</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19978</th>\n",
       "      <td>416A54345A374C6A78756A7766694353767053436F6F63...</td>\n",
       "      <td>2019/1/14 7:05:07</td>\n",
       "      <td>1</td>\n",
       "      <td>17777218395</td>\n",
       "      <td>杨友高</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19979</th>\n",
       "      <td>4E6F4C715132774B6847746C513335334B3754464F5A52...</td>\n",
       "      <td>2019/1/14 8:41:19</td>\n",
       "      <td>1</td>\n",
       "      <td>15393991380</td>\n",
       "      <td>巴艳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19980</th>\n",
       "      <td>53615A35664D3039333345516542396A75716C6A47514C...</td>\n",
       "      <td>2019/1/14 6:25:35</td>\n",
       "      <td>1</td>\n",
       "      <td>15378639062</td>\n",
       "      <td>卢芬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19981</th>\n",
       "      <td>536269416B6E2B326F6E345A7678446350666778386D31...</td>\n",
       "      <td>2019/1/8 5:10:13</td>\n",
       "      <td>1</td>\n",
       "      <td>18158331376</td>\n",
       "      <td>龙银全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19982</th>\n",
       "      <td>6854516C662F6748536C474D62496A7A375A2F556F5271...</td>\n",
       "      <td>2019/1/24 5:56:00</td>\n",
       "      <td>1</td>\n",
       "      <td>13315422777</td>\n",
       "      <td>陈保江</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19983</th>\n",
       "      <td>50594452554A502B343038346D65756864544F45743876...</td>\n",
       "      <td>2019/1/24 7:02:15</td>\n",
       "      <td>1</td>\n",
       "      <td>17783728877</td>\n",
       "      <td>何兵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19984</th>\n",
       "      <td>55706E7A53564338694D45457447454969514F47493757...</td>\n",
       "      <td>2019/1/23 8:07:35</td>\n",
       "      <td>1</td>\n",
       "      <td>13325128199</td>\n",
       "      <td>袁玉国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19985</th>\n",
       "      <td>2B787957494C39616448786E6C61594346726258653043...</td>\n",
       "      <td>2019/1/12 6:55:38</td>\n",
       "      <td>1</td>\n",
       "      <td>15349156600</td>\n",
       "      <td>孙启哲</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19986</th>\n",
       "      <td>4C6259414D45305A72446D6E324D675536514274335547...</td>\n",
       "      <td>2019/1/13 4:56:14</td>\n",
       "      <td>1</td>\n",
       "      <td>18909515060</td>\n",
       "      <td>韩莉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19987</th>\n",
       "      <td>552B3766385351717272722B7348774E664D754F626E6F...</td>\n",
       "      <td>2019/1/13 6:36:44</td>\n",
       "      <td>1</td>\n",
       "      <td>18072985702</td>\n",
       "      <td>周子高</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19988</th>\n",
       "      <td>48556859714D486F4567567031434A6C7337646B484443...</td>\n",
       "      <td>2019/1/8 8:00:34</td>\n",
       "      <td>1</td>\n",
       "      <td>18958761655</td>\n",
       "      <td>夏孟校</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19989</th>\n",
       "      <td>39332F527143654C4C324535466F6B56747974374B6D6C...</td>\n",
       "      <td>2019/1/10 8:17:44</td>\n",
       "      <td>1</td>\n",
       "      <td>15390892146</td>\n",
       "      <td>万其亮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19990</th>\n",
       "      <td>6A6F5766306D6A53562B564F314A6F3936497A484B7857...</td>\n",
       "      <td>2019/1/11 2:38:50</td>\n",
       "      <td>1</td>\n",
       "      <td>13315269839</td>\n",
       "      <td>颜晨旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19991</th>\n",
       "      <td>584D70754F784257354C514A597A546E72484D3075676C...</td>\n",
       "      <td>2019/1/13 9:25:45</td>\n",
       "      <td>1</td>\n",
       "      <td>18013276807</td>\n",
       "      <td>孙宗国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19992</th>\n",
       "      <td>76774F64747A324C6E576F5270794E6373746E41633445...</td>\n",
       "      <td>2019/1/13 11:26:07</td>\n",
       "      <td>1</td>\n",
       "      <td>17782830285</td>\n",
       "      <td>郑佩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19993</th>\n",
       "      <td>784758796555374C6C576B775A6B356E426D774B697172...</td>\n",
       "      <td>2019/1/14 3:37:02</td>\n",
       "      <td>1</td>\n",
       "      <td>18008585666</td>\n",
       "      <td>聂伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19994</th>\n",
       "      <td>4852573251626C653878475630347A624F486C52757A45...</td>\n",
       "      <td>2019/1/13 4:47:19</td>\n",
       "      <td>1</td>\n",
       "      <td>18997361277</td>\n",
       "      <td>扎西江才</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19995</th>\n",
       "      <td>3476612F5A31506F63765143596C6C34743872657A4545...</td>\n",
       "      <td>2019/1/10 8:03:23</td>\n",
       "      <td>1</td>\n",
       "      <td>18191591905</td>\n",
       "      <td>李龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19996</th>\n",
       "      <td>584D70754F784257354C51383450664476684974375757...</td>\n",
       "      <td>2019/1/12 3:20:27</td>\n",
       "      <td>1</td>\n",
       "      <td>17763046830</td>\n",
       "      <td>江培军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19997</th>\n",
       "      <td>354B67326A3461586B76434F6A4B464A6463526E437741...</td>\n",
       "      <td>2019/1/11 7:46:33</td>\n",
       "      <td>1</td>\n",
       "      <td>17778822625</td>\n",
       "      <td>马艳涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19998</th>\n",
       "      <td>377967352B7A50745435664B78444E6C6E493359784968...</td>\n",
       "      <td>2019/1/11 7:26:17</td>\n",
       "      <td>1</td>\n",
       "      <td>18078700907</td>\n",
       "      <td>孔祥贵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19999</th>\n",
       "      <td>496C35334C677A524F383065774C6F68356F7143776747...</td>\n",
       "      <td>2019/1/11 5:44:03</td>\n",
       "      <td>1</td>\n",
       "      <td>15343430200</td>\n",
       "      <td>王二牛</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20000 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          cert_no_cipher       complete_time  \\\n",
       "0      36724768494754335170662F47354B434D48527561644C...    2019/2/2 2:43:17   \n",
       "1      4A554F7A5758642F532F372B6E735A5038746A67303166...   2019/1/26 5:09:11   \n",
       "2      752B437272496C5442317378693049794743696E73332F...   2019/3/1 12:19:04   \n",
       "3      63514C305A4D57387A694F6B72366936666D38502F766B...   2019/2/11 4:20:18   \n",
       "4      6F4E62427547547948704657512B43687976494371612F...   2019/2/16 5:07:04   \n",
       "5      6F6557306F613758676A67314F754E5855344D594E6B2B...    2019/1/9 9:14:34   \n",
       "6      7347496C4847524B546F4A56396D79766743334F624635...   2019/2/13 3:57:37   \n",
       "7      37396D674D73334D413764652B4B484249656735326365...   2019/1/24 2:41:09   \n",
       "8      4F50732B38664E5A634F76764B4A716D78316935326C62...   2019/1/15 8:43:48   \n",
       "9      5454704E656747624930675769673343304F5A4E2F4B70...    2019/3/7 6:38:41   \n",
       "10     694F57615136566E5A304E51586248314F4A53714B6B37...   2019/1/12 9:22:31   \n",
       "11     32394C2F595A38702F39556445612F2B35502B55495855...   2019/1/27 1:14:45   \n",
       "12     3775707A2B7A734A6F66503956567A6A41563651356A53...    2019/1/4 6:45:39   \n",
       "13     6B476831597A5077745A5730324D73667066564E374F50...   2019/3/14 8:44:20   \n",
       "14     584475544D61547674496F314367476545744657556551...   2019/1/21 7:23:35   \n",
       "15     5A57774730307053764E6D527762434C592B3363454135...    2019/1/2 5:47:29   \n",
       "16     7A5372437576716D364672552F5871395273414D30792B...   2019/4/13 6:19:20   \n",
       "17     62737A644772564F704C7669567354646175596C655859...   2019/1/19 8:26:28   \n",
       "18     584B474D3461636B546833783731536575537A46505643...    2019/3/2 4:41:46   \n",
       "19     6D41446250427241633839336F6B4135672F756C4D6C57...   2019/1/19 8:14:21   \n",
       "20     514A465638514B73634B4C67527457395A325834685853...   2019/1/30 5:38:49   \n",
       "21     383461686E636C79656676323638305252556673627876...   2019/2/28 6:32:45   \n",
       "22     46656D443131505647614275554467454377314245487A...    2019/2/9 6:21:59   \n",
       "23     5774394A5A394E4B3046424E47322F7272683942457950...   2019/1/11 5:42:21   \n",
       "24     6E726E3779795855706F51513169753753544774664E65...   2019/7/15 3:19:44   \n",
       "25     6D5050504831325073594A657A424443494A374F634138...   2019/1/29 4:10:04   \n",
       "26     614F37372B452B566E62754B69474149766C4578305738...   2019/3/12 2:49:34   \n",
       "27     634A2B615165656D536F4A507878685955583353335337...   2019/2/27 5:05:14   \n",
       "28     64657A694E397877554A493664796130466F58555A5953...  2019/7/20 10:22:55   \n",
       "29     30416D357973676E354373627541436435796D706B3758...   2019/1/11 4:05:43   \n",
       "...                                                  ...                 ...   \n",
       "19970  63532F2B4A4A7531392B46467676494A4677474D777162...   2019/1/27 4:31:04   \n",
       "19971  734C6453723264563574502F42794D764B736F4B656973...   2019/1/27 5:19:14   \n",
       "19972  315971446939746C6D4C3448563348734731335171676E...   2019/1/27 2:59:40   \n",
       "19973  48416656744C624753697337566F31514338426853736B...   2019/1/26 6:21:19   \n",
       "19974  62737A644772564F704C765570573078756C4450386561...   2019/1/26 6:47:42   \n",
       "19975  6668316677655959736B2B69503449426C427971705031...   2019/1/13 7:22:44   \n",
       "19976  566B7274526334456E4E45764E2F4B303941306E354474...   2019/1/13 2:09:56   \n",
       "19977  387A4D647135543944736431473277326C396C785A6176...   2019/1/15 8:09:45   \n",
       "19978  416A54345A374C6A78756A7766694353767053436F6F63...   2019/1/14 7:05:07   \n",
       "19979  4E6F4C715132774B6847746C513335334B3754464F5A52...   2019/1/14 8:41:19   \n",
       "19980  53615A35664D3039333345516542396A75716C6A47514C...   2019/1/14 6:25:35   \n",
       "19981  536269416B6E2B326F6E345A7678446350666778386D31...    2019/1/8 5:10:13   \n",
       "19982  6854516C662F6748536C474D62496A7A375A2F556F5271...   2019/1/24 5:56:00   \n",
       "19983  50594452554A502B343038346D65756864544F45743876...   2019/1/24 7:02:15   \n",
       "19984  55706E7A53564338694D45457447454969514F47493757...   2019/1/23 8:07:35   \n",
       "19985  2B787957494C39616448786E6C61594346726258653043...   2019/1/12 6:55:38   \n",
       "19986  4C6259414D45305A72446D6E324D675536514274335547...   2019/1/13 4:56:14   \n",
       "19987  552B3766385351717272722B7348774E664D754F626E6F...   2019/1/13 6:36:44   \n",
       "19988  48556859714D486F4567567031434A6C7337646B484443...    2019/1/8 8:00:34   \n",
       "19989  39332F527143654C4C324535466F6B56747974374B6D6C...   2019/1/10 8:17:44   \n",
       "19990  6A6F5766306D6A53562B564F314A6F3936497A484B7857...   2019/1/11 2:38:50   \n",
       "19991  584D70754F784257354C514A597A546E72484D3075676C...   2019/1/13 9:25:45   \n",
       "19992  76774F64747A324C6E576F5270794E6373746E41633445...  2019/1/13 11:26:07   \n",
       "19993  784758796555374C6C576B775A6B356E426D774B697172...   2019/1/14 3:37:02   \n",
       "19994  4852573251626C653878475630347A624F486C52757A45...   2019/1/13 4:47:19   \n",
       "19995  3476612F5A31506F63765143596C6C34743872657A4545...   2019/1/10 8:03:23   \n",
       "19996  584D70754F784257354C51383450664476684974375757...   2019/1/12 3:20:27   \n",
       "19997  354B67326A3461586B76434F6A4B464A6463526E437741...   2019/1/11 7:46:33   \n",
       "19998  377967352B7A50745435664B78444E6C6E493359784968...   2019/1/11 7:26:17   \n",
       "19999  496C35334C677A524F383065774C6F68356F7143776747...   2019/1/11 5:44:03   \n",
       "\n",
       "       is_overdue   mobile_nbr user_name  \n",
       "0               0  13378020600       赵智清  \n",
       "1               0  18907523452       占兴武  \n",
       "2               0  18060278836       李洪发  \n",
       "3               0  17770301204       辜庭钟  \n",
       "4               0  18988393604       杨丽萍  \n",
       "5               0  18909358393       杨天斌  \n",
       "6               0  17709791659       裴正露  \n",
       "7               0  18175790586       何少军  \n",
       "8               0  18067713005       方万云  \n",
       "9               0  13302715598       洪泽荣  \n",
       "10              0  18137773659       成本芳  \n",
       "11              0  18934393557       崔家荣  \n",
       "12              0  18992555091       甘琪全  \n",
       "13              0  18003544444       石云峰  \n",
       "14              0  18097472389       安明善  \n",
       "15              0  18997648672        甄芸  \n",
       "16              0  18195174561        王凯  \n",
       "17              0  18135935950        路祥  \n",
       "18              0  15336129222       李春芳  \n",
       "19              0  17720365380       郝明章  \n",
       "20              0  18932676097       刘建龙  \n",
       "21              0  17331617007       史春龙  \n",
       "22              0  18990031920        孙建  \n",
       "23              0  13399996669       张君新  \n",
       "24              0  18128909150       周金清  \n",
       "25              0  13317337133        张斌  \n",
       "26              0  17362500590       王定全  \n",
       "27              0  18976326545       庹兴胜  \n",
       "28              0  18103301169       王英华  \n",
       "29              0  18969055678       阚建利  \n",
       "...           ...          ...       ...  \n",
       "19970           1  13320642130        吴军  \n",
       "19971           1  18005707088       王素军  \n",
       "19972           1  17764908905       黄明英  \n",
       "19973           1  17763941351       胡亚贵  \n",
       "19974           1  13303483112       王兴坤  \n",
       "19975           1  18968553952       庞建民  \n",
       "19976           1  17705987397       邓茂官  \n",
       "19977           1  13305765221       金良江  \n",
       "19978           1  17777218395       杨友高  \n",
       "19979           1  15393991380        巴艳  \n",
       "19980           1  15378639062        卢芬  \n",
       "19981           1  18158331376       龙银全  \n",
       "19982           1  13315422777       陈保江  \n",
       "19983           1  17783728877        何兵  \n",
       "19984           1  13325128199       袁玉国  \n",
       "19985           1  15349156600       孙启哲  \n",
       "19986           1  18909515060        韩莉  \n",
       "19987           1  18072985702       周子高  \n",
       "19988           1  18958761655       夏孟校  \n",
       "19989           1  15390892146       万其亮  \n",
       "19990           1  13315269839       颜晨旭  \n",
       "19991           1  18013276807       孙宗国  \n",
       "19992           1  17782830285        郑佩  \n",
       "19993           1  18008585666        聂伟  \n",
       "19994           1  18997361277      扎西江才  \n",
       "19995           1  18191591905        李龙  \n",
       "19996           1  17763046830       江培军  \n",
       "19997           1  17778822625       马艳涛  \n",
       "19998           1  18078700907       孔祥贵  \n",
       "19999           1  15343430200       王二牛  \n",
       "\n",
       "[20000 rows x 5 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all = pd.concat([last,overdue], ignore_index=True, sort=True)\n",
    "all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-14T10:17:18.907741Z",
     "start_time": "2019-11-14T10:17:12.853923Z"
    }
   },
   "outputs": [],
   "source": [
    "all.to_excel('vip.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
